Forum Discussion
Guage Percenatge
My guage is show like this instead of a percentage:
This is the measure:
It's set to 'no calculation', if I set it to 'percentage' it goes to 100.
% of responses which are positive =
DIVIDE (
CALCULATE (
[Total Responses],
FILTER (
'CSAT Survey Data 2017',
'CSAT Survey Data 2017'[Satisfaction Level] = "Excellent"
|| 'CSAT Survey Data 2017'[Satisfaction Level] = "Good"
)
),
[Total Responses],
0
)
- Anonymous9 years ago
Select your Measure or Column that forms this value. What data type is it? You can see this from the Modeling tab in the ribbon. It should be formatted as a Percentage.
Hi Anonymous,
As Ross73312 said, you can format the measure value under the Modeling tab. Please see below image.
Best regards,
Yuliana Gu
2 Replies
- AnonymousNot applicable
Select your Measure or Column that forms this value. What data type is it? You can see this from the Modeling tab in the ribbon. It should be formatted as a Percentage.
- v-yulgu-msft
Microsoft Employee
Hi Anonymous,
As Ross73312 said, you can format the measure value under the Modeling tab. Please see below image.
Best regards,
Yuliana Gu