Forum Discussion
WallyWallWal
8 years agoHelper I
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 runni...
- 8 years ago
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
8 years agoMicrosoft Employee
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
WallyWallWal
8 years agoHelper I
Thanks, v-yulgu-msft! This truly helped me out and understand how to create the gauge display correctly. Appreciate the help!