Forum Discussion
Helper IAverage and StDev lines on different aggregate charts
Hi michaelmichael ,
Could you share a sample Power BI file? That will make it easier to help you.
You can upload your Power BI file to One Drive, Google Drive or other similar tool and share it here.
Let me know,
LC
Interest in Power BI and DAX templates? Check out my blog at www.finance-bi.com
Solution SageHi michaelmichael ,
I am glad you found a solution!
Do not hesitate if you have further questions
LC
Helper Ilc_finance Sorry for the confusion, I have not found a solution. I have found a paid Add On, but I'd like to do this myself using Measures.
I pressed solution by accident
PaulDBrownCommunity Champion
It is very helpful to see the data in a table format when things don't seem to work out.
Here is an example:
So, to get the average Line and Standard Deviation Values you need to have a measure which removes the filter context, ie an ALL or ALLSELECTED.
The column in green for example is a simple CALCULATE([Aver. - std dev calc], ALLSELECTED(Values_Table)).You will need the equivalent measure for your average for it to plot on the Line Chart Visual.
Hope this helps.
Best.
- michaelmichael
PaulDBrown thanks for your help, putting the data into table view, rather than line graph helps.
But when I try your suggested formula for a new measure or column it won't let me use [Standard Deviation of Sub Group Values] as an expression after CALCULATE?
Sorry my formula knowledge is lacking somewhat, but what I'm after is a whole column in this table visual displaying 0.13, and then one with 0.13+StDev of the values
Thanks
- lc_finance
Hi michaelmichael ,
You can find attached an example for the whole column showing the total standard deviation.
Total Standard deviation = CALCULATE(STDEV.P('Table'[Values]), ALL('Table'[x-axis]))As PaulDBrown mentioned, you can use ALL or ALLSELECTED for that.
This is what it looks like:
Does this help you?
Regards,
LC
Interested in Power BI and DAX templates? Check out my blog at www.finance-bi.com