Why does the text in my own measure override the locale settings?

[B3rky]

Why does the text in my own measure override the regional settings? ... and is there something I can do about it?

I am using Czech regional settings (so the decimal separator should be comma).

Everything works just fine when I am using my own measure without any text (the purpose of this measure is to display the last value, nothing special):

... but when I also insert any text there, it just completely ignores my regional settings and uses decimal point instead:

I was trying to use the FORMAT function to fix it, but that didn't help either.

Is there a way how to fix it?

Thank you ...

[PaulDBrown]

You can format the original measure as a currency and select Euro

[PabloDeheza · Accepted solution]

Hey There!

You can try using the FORMAT() function this way:

FORMAT( [YourValue], "#,0.##", "de-DE" ) & " EUR"
Add the third parameter with "de-DE", this will force the value to use dot as thousand separator and comma as decimal separator.
The images below reflect the solution

[B3rky]

Thank you so much, it works!

This is exactly what I was looking for, I just couldn't get the FORMAT function to work properly.