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.
hello,
for the currency column, I'm having problems with decimal separator and thousand separator.
Decimal separator is a comma and thousand separator is a point. But PowerBi goes wrong
for example - powerbi shows 121,000.00 (thousand separator is a comma and Decimal separator is a point)
Output expected, 121.000,00 (Decimal separator is a comma and thousand separator is a point)
Thanks
Solved! Go to Solution.
The display of numeric felds (and dates, times etecetera) depends on your Regional Settings.
It can be adjusted in Power BI Desktop or in Windows (Land/Region). It looks like the Windows setting is leading, but you have to close and reopen your pbix file after adjusting the Regional Settings.
In Power BI you can also adjust your language settings to influence the display format for published reports.
Hello,
We have a power bi report embedded int .net application. We have given ($)United States format for one column in the report. It shows $123,345,678(Right format) in few browsers and machines and $12,33,45,678(wrong format) in few browsers.
Can some one help me to fix this please.
Thanks,
Power BI Learner
The Thousand Separator could not work, if the currency value contains more than 8 digits. Provide solution for this.
Helle all,
Thanks to this blogpost I have found a sulution for this problem without changing the locale for the whole Power Bi file. The steps are:
Example:
#"Type gewijzigd" = Table.TransformColumnTypes(#"Kolommen verwijderd",{{"sales.grand_total_month", type number}}, "en-US")
This is the right answer. I don't care about Regional Display, I want the Power Query to correctly parse my column as it is written.
Hi @RacAgr,
Based on test, if I export these data to csv, it will remove custom format and keep the normal number. So I think you store these value with text format, right?
Regards,
Xiaoxin Sheng
these values are in decimal number then using currency
Hi @RacAgr,
I can't reproduce your issue, It works well on my side.
Regards,
Xiaoxin Sheng
Output expected, 121.000,00 (Decimal separator is a comma and thousand separator is a point)
in your result, you get 121,000.00 (Decimal separator is a point and thousand separator is a comma), which i am able to get as well. but i need the output as shown in first line
The display of numeric felds (and dates, times etecetera) depends on your Regional Settings.
It can be adjusted in Power BI Desktop or in Windows (Land/Region). It looks like the Windows setting is leading, but you have to close and reopen your pbix file after adjusting the Regional Settings.
In Power BI you can also adjust your language settings to influence the display format for published reports.
Has something recently changed in this behaviour? I can't seem to get the xxx.xxx,xx formatting using the Locale setting..
I found the solution to my issue; PBI Desktop seems to be only looking at the "Region - Format" part in the Win10 - Control Panel - Clock and Region - Region settings e.g:
Format: Dutch (Netherlands). When customizing this format using the "Additional settings" button, these customizations are not taken into account by PowerBI Desktop; So, it's VERY important to pick the correct Format: selection and not customize an existing selection to the needs of your users.
Created a blogpost around my findings on this.
It works. Important: All figures on data model should have the same type. Be careful when you were transforming data
this is the correct format as far as i know.
powerbi shows 121,000.00
Proud to be a Super User!
any suggestions pls on how to achieve the expected output?
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |