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
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
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.