The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |