Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello! I have the following gauge with the 34 placed in value, and 80 placed in maximum value.
We would like to see this displayed as a percentage, so a 43% out of 100%. However, if I attempt right clicking the values and then clicking on "Show as Percentage of Grand Total" the following happens.
I have also attempted by using the following formula and placing it on the value field:
Please note I do NOT have access to Power BI Desktop and can only build from Power BI Services.
Hey @NatureChips ,
in addition to what @v-kaiyue-msft already mentioned, you can achieve that the callout value is showing up as a percentage while the max value of the gauge still shows as an absolute value.
To achieve this I created two measures, the first one represents the MAX value for the gauge:
vizAid max for Callout Value in Gauges = 20000000
I assigned this measure to the MAX setting of the Gauge:
Then I created a measure that makes the Division:
vizAid percent for Callout Value in Gauges = DIVIDE( CALCULATE( SUM( 'FactOnlineSales'[SalesQuantity] ) ) , [vizAid max for Callout Value in Gauges])
Then you can use this measure with the custom label in the settings of the callout value:
Finally format the measure as percentage:
Hopefully, this helps to tackle your challenge.
Regards,
Tom
Hi @NatureChips ,
Using Expressions
% = FORMAT(DIVIDE([Sum of TrainedEmployees],[%GT Count of TotalEmployees])/100, "0.00%")
The reason it is not displayed in the gauge visual object is because the format function converts the result to a text format, whereas this visual object expects the result to be in a numeric format.
You can change the expression to
DIVIDE([Sum of TrainedEmployees],[%GT Count of TotalEmployees])/100
Set the maximum value to 1
If possible, it is recommended that you use power bi desktop, as it is easy to achieve results using its built-in formatting tools.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.