Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 €
Solved! Go to 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
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
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
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |