cancel
Showing results for
Did you mean:
Highlighted
Frequent Visitor

## How do I format the Gauge Visual to display a decimal value as a percentage (%)?

…like I would format the same value to display a certain number of decimals point. Using Direct Query so the model can’t be altered.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft

## Re: How do I format the Gauge Visual to display a decimal value as a percentage (%)?

Hi jahall4,

We could also change the data type in the report view, in Report View, select the Gauge Visual, then choose the value in the Fields, under Modeling tab, there would also be the Data type available to modify:

As as you could see, if only for the column data, Gauge would just display the the sum of the column, so if you would like to have a percentage displayed, we need to create a measure ( filter some special data from the data range, then divide it with the total. Or, we need a slicer visual to help showing the proper precentage) and then put the measure into Gauge Visual.

Regards

6 REPLIES 6
Highlighted
Community Champion

## Re: How do I format the Gauge Visual to display a decimal value as a percentage (%)?

@jahall4 In power bi destop under Modelling tab, highlight your value column and click on '%' icon under formatting.

Highlighted
Microsoft

## Re: How do I format the Gauge Visual to display a decimal value as a percentage (%)?

Hi jahall4,

We could also change the data type in the report view, in Report View, select the Gauge Visual, then choose the value in the Fields, under Modeling tab, there would also be the Data type available to modify:

As as you could see, if only for the column data, Gauge would just display the the sum of the column, so if you would like to have a percentage displayed, we need to create a measure ( filter some special data from the data range, then divide it with the total. Or, we need a slicer visual to help showing the proper precentage) and then put the measure into Gauge Visual.

Regards

Highlighted
Frequent Visitor

## Re: How do I format the Gauge Visual to display a decimal value as a percentage (%)?

The UI you have screen shot (best I can tell because of the pixelisation) is not avaible to me. Looks like maybe you are working in the model? Is your data source Direct Query?

Highlighted
Frequent Visitor

## Re: How do I format the Gauge Visual to display a decimal value as a percentage (%)?

Thanks Michael,

This was a "buger" to find. I kept looking for this as part of the Gauge Visual's properties since you can format there for decimal places. I guess I'm expecting too much continuity for such a young product.

Note: I think on the report this is the only way it can be done because we are using Direct Query

Highlighted
Regular Visitor

## Re: How do I format the Gauge Visual to display a decimal value as a percentage (%)?

There does not seem to be any way to achieve this with a Direct Query. I hav ethe same issue with the Power BI gauge on a report connected LIVE to a multi-dimensional cube. The calculated measure in the cube is formated as "Percent" however

• The gauge shows this as a numeric value (e.g. 0.03 for 3%), despite the source models format
• The properties on the modelling tab are not available to change thje format fo rthis attribute (as this is a LIVE query - the model is stored outside Power BI Desktop)
• The gauge properties (still) do not allow formatting of the data as a % (only allows the font, units and number of decimal places to show)

Ideally the gauge picks up and uses the formatting defined on the multi-dimensional model for a live connection - currently the gauge does not do this.

Highlighted
Regular Visitor

## Re: How do I format the Gauge Visual to display a decimal value as a percentage (%)?

There seems to be an issue with some built-in visualizations in Power BI when it comes to % measures in a SSAS MD Cube. i.e.:

• I have a calculation measure in a SSAS MD Cube that is configured with a format of "Percent"
• When this measure is exposed on a Power BI table it correctly displays as a % value (e.g. 2.05%)
• However when this measure is used on a Bar Chart, Column Chart, Gauge, etc. it's value is displayed as a decimal value (e.g. 0.0205), which is confusing for end-users / POwer BI consumers.

This issue is present in Power BI Desktop "March 2018" version as well as the March 2018 release of PBIRS (Power BI Report Server).

It means that in order to prevent confusing users I need to avoid using rich visualisations for % values and keep these corralled in either a table or a matrix viausalisation 😞

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

#### Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors