Format percentage 9,9,9%

[joostraaphorst]

Since today the format of percentage measures has changed.

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

Anyone facing this issue?

[rayz]

@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]

@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]

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!

[rayz]

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

[SanderBeukers]

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.

[v-yuezhe-msft]

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?

Thanks,
Lydia Zhang

[WVonk]

Hi Lydia,

i am facing exactly the same problem with 3 of my (Dutch) customers and my own dashboards. The same problem is also there with the latest Power BI version (2.38.4491.282).

Is there any more information available? 1 of my customers is testing the Board dashboards right now and this was een unpleasant suprise!

[SanderBeukers]

I am currently in the proces of examining the issue with Microsoft. A recent reply i've got indicates that the problem is broad:

Quote:

---

Microsoft wrote:

Hello Sander,

The issue seems to be known but I would like to do some tests and investigations. Hence please advise your feedback for the questions below.

---

Unfortunatly i dont have the time to reply Microsoft untill monday, so no solution yet.

[WVonk]

Hi Sander,

Thanx for the update! Good to hear that the problem is under investigation. Happy to hear when there is more information available!

[SanderBeukers]

Just recieved an update:

"Hello Sander,

Hope you are enjoying the weekend. I have communicated with my internal resources and this is a known issue. The product team are currently working on the fix. I will follow up and update you whenever it is resolved. It is needless to keep the case open so I will go ahead and archive it.

Kind regards"

Hoping for a quick fix soon.

[joostraaphorst]

Hello Joost,

                I hope all is well. I called earlier and left a voicemail. It has been confirmed that this is a Product defect. The ETA for the fix is end of September (with the release of PBI Desktop for September). A workaround could be setting three digits of precision for your percent format should cause the commas to align correctly.

I will proceed with closing this ticket at this time. Please feel free to reach out to me if you have any questions. Thanks very much for your patience on this matter.

 

Sincerely

Wilfred Adelowo

[WVonk]

Thanx for the update Joost!

[joostraaphorst]

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.

[rayz]

Scroller 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

[rayz]

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