Forum Discussion
thousands separator in pdf report export
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
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.