cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joostraaphorst Frequent Visitor
Frequent Visitor

Format percentage 9,9,9%

Since today the format of percentage measures has changed.

It shows 9,9,9% instead of 9,99%.

Anyone facing this issue?

Format percentage.png

15 REPLIES 15
rayz Frequent Visitor
Frequent Visitor

Re: Format percentage 9,9,9%

I also have this issue as of today. It only seems to appear in the web application and only affects percentages.

Moderator v-yuezhe-msft
Moderator

Re: Format percentage 9,9,9%


Hi @joostraaphorst,

I am not able to reproduce your issue. When I view Gauge Chart in Power BI Desktop and Power BI Service, the percentage measure displays properly as follows. Do you use the latest version of Power BI Desktop(2.37.4464.602) to create Gauge Chart? How do you create your percentage measure?
Capture.PNG


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rayz Frequent Visitor
Frequent Visitor

Re: Format percentage 9,9,9%

Naamloos.pngScroller percentage

@v-yuezhe-msft It seems not limited to the gauge visual. I have this problem in the Scroller visual and the line chart visual. In my case the measure is a DAX measure that is formatted as percentage with 2 decimals by Power BI.  If you view the data table of the visual, the percentages look fine

joostraaphorst Frequent Visitor
Frequent Visitor

Re: Format percentage 9,9,9%

Hi Lydia,

thanks for your reaction.

 

Our dataset is a SSAS tabular model, where we have defined the format of the percentage with 1 decimal.

We are not using Power BI Desktop. We build the dashboard in the PowerBI app in Office 365.

When we select the measure in a table it shows up correct, but in a visual it shows up with 2 decimals and an extra decimal point.

 

Percentage Decimal Points.pngFormat percentage visuals.png

 

rayz Frequent Visitor
Frequent Visitor

Re: Format percentage 9,9,9%

It looks like a localization/language problem; if I switch the Power BI language from Dutch to English, the percentages are displayed correctly. 

SanderBeukers Regular Visitor
Regular Visitor

Re: Format percentage 9,9,9%

I am also facing this problem. Changing the language from dutch to english seem to be a workaround. I'm assuming Microsoft made some behind the scene changes which is causing this.

rayz Frequent Visitor
Frequent Visitor

Re: Format percentage 9,9,9%

@v-yuezhe-msft How can we move forward on getting this fixed? Do I need to open a support issue or is the Power BI Team already aware of this issue?

joostraaphorst Frequent Visitor
Frequent Visitor

Re: Format percentage 9,9,9%

@rayz I have raised an ticket at Power BI Basic support. It's not a paid support ticket so the priority is not that high.

SanderBeukers Regular Visitor
Regular Visitor

Re: Format percentage 9,9,9%

Thanks, if you could post a reply when you get a respons, that would be greatly appreciated. Also: was not aware a free ticket could be logged, good to know!