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
Helper Ilc_finance if it helps, I've found a PowerBI Add On which can give these visual results, called Craydec Control Charts
But this costs to run, when I'm certain I can script the file to run the same thing
Solution SageHi michaelmichael ,
I am glad you found a solution!
Do not hesitate if you have further questions
LC
- michaelmichael
lc_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