Format numbers

[CarlsBerg999]

Hi,

Is there a way to format numbers with DAX? I've been trying to find a way to present 3 111 000,00€ But what i get is 3.100.100,00€. I can't change the localization of my PowerBI Desktop and i can't find this formatting in the Currency -settings of a measure. 

Any ideas? The goal is to have a space as the thousand separator and comma as a decimal point. E.g: 3 111 000,00 €

[Anonymous]

Hi @CarlsBerg999,

Did HotChilli 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[HotChilli · Accepted solution]

You can define your own format in Data view.  The details are here:

https://docs.microsoft.com/en-gb/power-bi/create-reports/desktop-custom-format-strings 

It might be something like this

# ### ###.##€

The decimal placeholder is defined using .   but the actual character comes from regional settings on the pc / regional settings in the report