Forum Discussion

acco's avatar
acco
Frequent Visitor
9 years ago

Problem with number formatted as currency

Hi everyone,

 

I've got a problem and I can not find a solution: I've Power Bi Desktop installed on my computer (WIndows 10 pro x64). The source data are some excel files. The locale settings on Windows are set on "Italian (Italy)" but on Power Bi Destop some value are displayed in different ways (and it changes from what I've got published online).

This a screenshot of the problem:

The first number displays quite correctly, the only problem is the € symbol displayed at the end of the number (instead the locale setting should be "- € 0.000,00".

The second number displays minus sign and currency value togheter at the end.

The third number present a different problem: the number uses "." to separate decimals instead ","

 

Any suggestion will be so much appreciate!

 

Best regards

Fabio

Need Help

2 Replies

    • acco's avatar
      acco
      Frequent Visitor
      9 years ago

      Hi Qiuyun,

       

      Thanks for your replay. Unfortunately what you suggest me is allready done. This is the main reason which I've opened this thread, I've no idea whats's wrong with my system.

       

      Thank's

      Fabio