How to change a dot to a comma in a visualization?

[Gjakova]

Hi all, I was wondering if someone knows how to change a dot to a comma in a visualization? I have the following two measures:

Symbol:

This week:

I am visualising the output in a multi row card. The numbers come out like this: € 1.438

But I want that the output is € 1,438 (thus, a comma instead of a dot).

How do I need to change the measure to make this possible? Formatting it is not possible. I took a look at this website, but I couldn't make it work and don't know how: https://docs.microsoft.com/en-us/dax/custom-numeric-formats-for-the-format-function

Thanks in advance for your help!

[v-gizhi-msft · Accepted solution]

Hi,

You can try this:

Format_Measure = SUBSTITUTE([Measure],".",",")

The result shows:

Best Regards,

Giotto

[Gjakova]

@v-gizhi-msft  Thank you so much! Thanks to your table I also realized that had to create a new measure to transform the old measure from a . to a ,

I will definitely use this for future projects, so thanks again!

[Anonymous]

Hi @Gjakova ,

Something like this should work as a measure

Orders = FORMAT(SUM(Orders), "#,#") //for whole numbers

If you want to include decimal values, write it like this:

Orders = FORMAT(SUM(Orders), "#,#.#") //for 10th place rounding

Orders = FORMAT(SUM(Orders), "#,#.##") //for 100th place rounding

etc.

If your number is supposed to be a currency, write it like this:

Orders = FORMAT(SUM(Orders), "€#,#.##") //for currency with decimals

Orders = FORMAT(SUM(Orders), "€#,#") //for currency without decimals

Hope this helps

Nick

[Gjakova]

Hi @Anonymous Nick,

That could very well be the solution, but I just don't seem to get how I should apply this in my measure... I tried the following, but that does not work:

Would you happen to know what I'm doing wrong?

[RandyPgh]

Is it possibly the locale setting in Power Query? See the Chris Webb blog below.

https://blog.crossjoin.co.uk/2015/05/25/working-with-international-date-and-number-formats-in-power-...

[Gjakova]

Hi @RandyPgh 

In my data and query editor it does show the numbers with a comma instead of a dot (1,370 instead of 1.370), but in the visualisation it only shows up like 1.370 😑

If the locale setting is the issue, wouldn't it also show the dot at the data and query editor instead of only at the visualisation?

I tried the suggestion of Chris Webb's BI Blog, but that did not help...