cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
CarlsBerg999
Helper IV
Helper IV

Format numbers

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 €

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

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

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
HotChilli
Super User
Super User

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.