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 It is a very simple data table.
I have 2 columns, 1st is the supgroup (x axis), let's call these A-J. The 2nd column is a numerical value.
You can build a simple data set of A-J, with their corresponding data value (for this excercise this can be 10 entries for each letter, number between 1-10).
From this I produce 3 visuals, and with the data I have each visual as "Average", "StDev" and "Sum".
Thanks
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
lc_financeSolution Sage
Hi 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.