Forum Discussion

NastiaSiri's avatar
NastiaSiri
Frequent Visitor
2 years ago

Comma decimal separators changed to dot

Pleas help with changing the decimal separators back to comma. The data is loading correctly (with comma as saparator in Power Query). But visualiwed with a dot instead. I have change the prefences both for Power BI and Windows, but nothing helps, it is driving my crazy. 

Power Query            Visual       

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi NastiaSiri ,

     

    The Belgium number format is with dots. can you set the Regional format to ENglish (United Kingdom) and try.

     

    Cheers

     

    CheenuSing

    • NastiaSiri's avatar
      NastiaSiri
      Frequent Visitor

      Hi,

       

      In Belgium with use comma as a decimal separator and a dot as grouping, which is what I need. I have it installed in my Windows, but Power Bi chnages it to dots anyway. 

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi NastiaSiri ,

    Please try this way in Power Query:
    Right-click the list header.


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

     

    • NastiaSiri's avatar
      NastiaSiri
      Frequent Visitor

      the numbers on the visualisation level stay just the same (incorrect way)