Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Need help to add an average line to bar chart.
These measures are calculated through CALCULATE and COUNT with FILTER, etc.
I want to show them in bar chart with and an average line shows across the bars. Like below:
However, when I use Line and Staked Column Chart and put the TEST to the Line Values, it shows below. Can someone suggest a way to solve.
Thanks in advance.
Solved! Go to Solution.
HI @Anonymous,
On the analytics tab of the clustered column visualization you can choose to add an average line. Select the measure that you want to average from the dropdown for the measure.
HI @Anonymous,
On the analytics tab of the clustered column visualization you can choose to add an average line. Select the measure that you want to average from the dropdown for the measure.
This is awesome! THANK YOU! I couldn't get my measure to work. This gives me what I was looking for. Hopefully, my customers agree.
HI @Anonymous,
It will be help if you share some sample data.
BTW, if your percentage value is from measure, I don't think you can direct use other measure to calculate average on it.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |