Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |