Forum Discussion

vickyd's avatar
vickyd
Helper V
8 years ago

Number formatting showing up differently for different users

We've published a report on Report Server. THe report connects to a SSAS data model.  A couple of users have reported that they are seeing the numbers formated differently from what I see it as.   ...
Formatting
locale
numbers
Ntn2018's avatar
Ntn2018
Frequent Visitor
8 years ago

One way is to create an aggregated measure that cast the number into string in the way you prefer. 

  • vickyd's avatar
    vickyd
    Helper V
    8 years ago
    Ntn2018wrote:

    One way is to create an aggregated measure that cast the number into string in the way you prefer. 

    Is there a user level setting that the user can change to make it show a certan way? Don't think I want to go with the above solution.  

    • vickyd's avatar
      vickyd
      Helper V
      8 years ago

      Issue appears to be in Internet Explorer and Edge and not in Chrome or Firefox. That too only some users have issue in IE/Edge, not all. 

       

      I myself have the issue in IE/Edge but not in Chrome. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        I'm not sure if this will work, but we use Tabular data sources and we force many of our measures to a specific format using the Custom format setting and then a FormatString. This seems to be unaffected by locale settings on user machines.

         

        I suspect the issue is probably due to an interaction with the users locale and the server locale of the PBI-SSRS Server.

         

        I haven't seen anywhere in PBI-Desktop that you can set the locale of the PBIX/Page/Measure like you can in SSRS reports