Forum Discussion

joostraaphorst's avatar
joostraaphorst
Frequent Visitor
10 years ago

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?

15 Replies

  • rayz's avatar
    rayz
    Frequent Visitor

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

    • SanderBeukers's avatar
      SanderBeukers
      Advocate I

      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's avatar
    rayz
    Frequent Visitor

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

  • Anonymous's avatar
    Anonymous
    Not applicable


    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

    • rayz's avatar
      rayz
      Frequent Visitor

      Scroller percentage

      Anonymous 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's avatar
      joostraaphorst
      Frequent Visitor

      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.

       

       

    • WVonk's avatar
      WVonk
      Frequent Visitor

      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's avatar
        SanderBeukers
        Advocate I

        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.

  • rayz's avatar
    rayz
    Frequent Visitor

    Anonymous 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's avatar
      joostraaphorst
      Frequent Visitor

      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's avatar
        SanderBeukers
        Advocate I
        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!