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