Forum Discussion
Gauge visualization not functioning as intended
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!
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
3 Replies
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
Thanks, v-yulgu-msft! This truly helped me out and understand how to create the gauge display correctly. Appreciate the help!
v-yulgu-msft If I wanted to change this to a percentage, how do I go about doing that? Thanks.
