standard deviation and smallest worthwhile change

[andyg10]

Does anyone know if it is possible to view the standard deviation/smallest worthwhile change 'zone' in a chart or custom visual - to show how much data may vary from these?

Thank you

[v-yuezhe-msft]

@andyg10,

You can firstly use Power BI built-in functions such as STDEVX.P and STDEVX.S to calculate standard deviation, then drag the calculated values to your chart. For more details, please take a look at the following blog.

http://www.dash-intel.com/powerbi/statistical_functions_stdev.php

Regards,
Lydia