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.
Hello
I am sitting with a line and clustered column chart, where I have made a measure to show average.
this is represented by a line. The columns show the individual values.
Now what I would like to do is use a card (or something like that) to show how far from the average, the individual column is.
(The idea is to pick one specific column, so only this is displayed.
Any way to do this?
Or any suggestions how to do this a better way?
Solved! Go to Solution.
Hi @BiBra,
Please try below measures:
Average = CALCULATE(AVERAGE('Test Data'[Sales Value]),ALL('Test Data')) Difference from average = SUM('Test Data'[Sales Value])- [Average]
Best regards,
Yuliana Gu
Hi @BiBra,
Please try below measures:
Average = CALCULATE(AVERAGE('Test Data'[Sales Value]),ALL('Test Data')) Difference from average = SUM('Test Data'[Sales Value])- [Average]
Best regards,
Yuliana Gu
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |