Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I'm using a Line and Cluster Column Chart to display three different data categories. The x axis is the date.
Example: data is in the form below
Date A B C
8/1/17 5 3 7
8/2/17 4 8 2
8/3/17 6 5 9
etc
I want to add an average line for one of the data categories. The Line and Cluster Column Chart does not have an Average Line in the Analytics, only a trend line. When I try to calculate an average measure or use Quick measures i just get the data values returend because I'm including date in the graph
Is there a way to add an average line in?
Thanks
Solved! Go to Solution.
Hi @mbd,
You can create a measure to calculate average values, take the column A as a example:
Avg(A) = CALCULATE(AVERAGE('Table2'[A]),ALLSELECTED('Table2'))
Then drag this measure to the Line Values property of the combo chart. For details, you can download attached pbix file to have a look.
Best Regards,
Qiuyun Yu
Hi @mbd,
You can create a measure to calculate average values, take the column A as a example:
Avg(A) = CALCULATE(AVERAGE('Table2'[A]),ALLSELECTED('Table2'))
Then drag this measure to the Line Values property of the combo chart. For details, you can download attached pbix file to have a look.
Best Regards,
Qiuyun Yu
Hi,
Ignore my question on Shade Area. I just needed to update my desktop version.
Thanks for the help
Thanks!, that worked.
I have two of my data sets as lines and one as a column. I want to shade one of the line data sets.
In Format, I've turned Shade Area on, but it won't let me turn off Shade Area for my other data set. It shades both of them and now the Avg measure also.
Is there a way to add shade area to only on line?
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |