Forum Discussion

Jdrien's avatar
Jdrien
Frequent Visitor
1 year ago
Solved

thousands separator in pdf report export

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 ...
  • divyed's avatar
    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