thousand separator showing wrong in power BI service

Anonymous — Wed, 11 Dec 2024 15:23:10 GMT

Hi Team,

The 1000 seprator showing correctly in report builder, but after publishing in Power BI report server, its showing worng format.

Please may i know the fix for this.

In Report Builder:

In Report Server:

Re: thousand separator showing wrong in power BI service

Anonymous — Wed, 25 Dec 2024 08:54:16 GMT

Hi,Anonymous .I am glad to help you.

I think this is an issue caused by inconsistent language region settings in the power bi report builder and the power bi service (i.e. browser default language).

The results you show in Report Buider are

100,000

This format is the international standard

Whereas in Power BI Service, the results displayed are

1,00,000

This is the format is Indian number system. In this system, the thousands separator appears once after every two digits. For example, one hundred thousand would be written as 1,00,000
This is my test:

This is what the report shows me by default (with no language field set)

Here I have set the language of the paginated reports to en-us in order to standardize the language area of the power bi service and the report builder.

Presentation results for Power BI Service and Report Builder

The language used in the power bi service is your browser's default setting.
I am using my browser's default English

Unfortunately, after trying several languages here (Spanish, German, etc.)
The numeric data in power BI Service is still the same as in Report Builder.(During my test, changing the language of the browser did not affect the data presentation format of the paginated reports)

So I think one way to solve your problem is to modify the data formatting in the report builder.
1. Modify the data type

It is important to note that the problem you are experiencing is simply a difference in the presentation of the format, and the actual data has not changed.
The official solution to this formatting inconsistency is the same.
Changing the numeric type to a text type that doesn't change in any way will avoid the problem you're having (if your data is only used for presentation and is not involved in data manipulation)
This is also why I created a Num Text column (the text data itself will not be affected no matter how the formatting is modified)
This ensures that the user will see the same text no matter which way they view the report.
URL:
Format numbers and dates in Power BI paginated reports - Power BI | Microsoft Learn
Format text and placeholders in paginated reports - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn
Changing regional settings of a report in services - Microsoft Fabric Community

like this:

=FORMAT(Fields!YourFieldName.Value, "N0") =FormatNumber(Fields!YourFieldName.Value, 3)

I'll add here that by changing the language settings in your Power BI Service you may be able to solve your number formatting problem

Suggestion 2:
Change the language settings in the paginated reports(Power BI Report Builder):

Force a language format for the data cells of the paginated reports, so that the paginated reports do not use the default data format of the system's current locale, and so that no matter where the data is displayed, the paginated reports should prioritize the language data format you have set.

This explains why I couldn't reproduce your problem in my previous test: I had already forced language =en-us for the cells in the design phase of the paginated reports, then when presenting the results in Power BI Service, the system prioritizes the data in the format set by the user (this is also described in the documentation, unfortunately I ignored it)
URL:
Solved: Report Builder and Format Numbers - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: thousand separator showing wrong in power BI service in Report Server

thousand separator showing wrong in power BI service

Re: thousand separator showing wrong in power BI service