Forum Discussion
PowerBi Desktop Currency format
Hello, i have some troube with tha way my data is showing. The currency appears xxxx,xx, and I need xxx,xxx,xxx. I've already tried to change it from qwery and custom, but it doesn't work.
In the image, it supose to be 19,126,026 (nineteen million...)
This might have something to do with your regional settings. Your format works fine on my end. You might want to try changing the formatting from the model view:
7 Replies
This might have something to do with your regional settings. Your format works fine on my end. You might want to try changing the formatting from the model view:
Hi juligil ,
Thank you for reaching out to the Microsoft Community Forum.
Option 1: Change Data Format Locale in Power BI:
1.Go to your table visual → click on the field showing the currency (e.g., in the Values section).2.In the Model view, select that field.
3.On the Properties pane, find Format > set it to Currency.
4.Just below that, locate Locale or Format using locale.
5.Choose a locale that uses the US-style format, such as: English (United States) → comma as thousand separator, dot as decimal.
6.Save and refresh.
Option 2: Change Data Type in Power Query: If Power BI imported your numbers as text:
1.Open Transform Data (Power Query Editor).
2.Select the column with currency values.
3.Use Replace Values to: Replace . with empty ("") and Replace , with .
4.Then, change the column type to Decimal Number or Currency.
5.Apply and close.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank youHi juligil ,
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank youHi @juligil ,
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank you
