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.
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
)
Solved! Go to Solution.
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 @johnbradbury,
As Ross73312 said, you can format the measure value under the Modeling tab. Please see below image.
Best regards,
Yuliana Gu
Hi @johnbradbury,
As Ross73312 said, you can format the measure value under the Modeling tab. Please see below image.
Best regards,
Yuliana Gu
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.
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 |
---|---|
116 | |
102 | |
78 | |
77 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |