Microsoft Business Intelligence

To create an alert on a report simple click on the three dots on right hand top of the report which in turn will open the menu as below. Once you see this menu, hit on bell icon to set your data alerts based on conditions how you want to be alerted.

When creating Charts in Power BI, you might get into situations where your graph may not show proper numbers or drill down to granular level might have issues due to NaN. The reason this problem exists is because of Divide By Zero error. When creating your Measures the easiest way to resolve this problem would be to user inbuilt DIVIDE formula which takes care of divide by zero automatically. Code : Measure = DIVIDE(SUM(COL1),SUM(COL2)); Up here you are dividing COL1 by COL2.