topic thousands separator in pdf report export in Report Server

thousands separator in pdf report export

Jdrien — Thu, 17 Oct 2024 15:30:18 GMT

Hello,
I'm French, so we don't have thousands separators.
i have a report on powerBI, everything is set corecly in the report,
numbers are like 124 325 450,20
no thousands separator and coma for decimal separator.
i use an azur api to export one page to a pdf, but all my numbers are now like this:
124,325,450.20
can someone help me with this?

Re: thousands separator in pdf report export

Anonymous — Fri, 18 Oct 2024 01:44:56 GMT

Hi, Jdrien

You can try to complete the region setting in Power query:

You can check out this discussion:

Incorrect locale (regional number formating) when ... - Microsoft Fabric Community

The official documentation mentions that the effect of exporting to PDF is not guaranteed:

Based on the above, I think you should try the following two methods:
Set your columns to text to prevent inconsistencies when exporting.
Method 2, translate your report into the corresponding language according to the following document:

Use locale values in multiple-language Power BI reports - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: thousands separator in pdf report export

divyed — Sun, 20 Oct 2024 12:11:41 GMT

Hello Jdrien ,

There can be many reasons . You can try some options :

1. Check Power BI Report Regional Settings under File > Options and settings > Options > Current file > Regional Settings

Set the Model Language and Locale for Import to your preferred region (e.g., English if you want a space as a thousands separator and a period for decimals)

2. Try formatting numbers using DAX by using below dax

Formatted Number = FORMAT([YourMeasure], "# ### ###.##")

Also don't forget to check Azure api settings, it could be applying different locale during export.

I hope this helps.

Did I answer your query ? Please mark this as solution.

I except Kudos as well 🙂

Cheers

Re: thousands separator in pdf report export

Anonymous — Tue, 22 Oct 2024 09:05:15 GMT

Hi, Jdrien

Have you already solved the current problem? You can share your answers here so that other members of the community can quickly find answers if they have similar questions.
Your cooperation will work with us to promote the development of the community. Thank you again!

Best Regards

Jianpeng Li

Re: thousands separator in pdf report export

Jdrien — Tue, 22 Oct 2024 09:09:13 GMT

HI !
Thx for your response, i tried and managed to fix this using divyed DAX solution, my numbers are now texts with the right format.