How to display data as percentage in a gauge visual

[NatureChips]

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:

% = FORMAT(DIVIDE([Sum of TrainedEmployees],[%GT Count of TotalEmployees])/100, "0.00%")

However, for some reason it will show it as blank despite showing a 34% on the table:

Please note I do NOT have access to Power BI Desktop and can only build from Power BI Services.

[TomMartens]

Hey @NatureChips , 

in addition to what @Anonymous 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

[Anonymous · Accepted solution]

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.