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! Newbie here... and first posting!!
I am trying to get the Gauge visualization to work and am having issues. I read how to get the total count so that it displays.
What I am running into is using two charts, and when clicking on one line of my bar chart, the gauge just gives me the total of that bar, not a count of the total. Looking for any help and/or suggestions! I was expecting to see 76 of 2185, but didn't get that. Thank you for the help!
Solved! Go to Solution.
Hi @WallyWallWal,
Please create two measures similar to:
Actual value = SUM(Table[Sales]) Total of all = CALCULATE(SUM(Table[Sales]),ALL(Table))
Add [Actual value] to 'Value' section of Gauge, add [Total of all] to 'Maximum value' section.
Best regards,
Yuliana Gu
Hi @WallyWallWal,
Please create two measures similar to:
Actual value = SUM(Table[Sales]) Total of all = CALCULATE(SUM(Table[Sales]),ALL(Table))
Add [Actual value] to 'Value' section of Gauge, add [Total of all] to 'Maximum value' section.
Best regards,
Yuliana Gu
@v-yulgu-msft If I wanted to change this to a percentage, how do I go about doing that? Thanks.
Thanks, @v-yulgu-msft! This truly helped me out and understand how to create the gauge display correctly. Appreciate the help!
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 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |