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,
I would like to replace dot to comma for numbers.
In power query and data view commas are decimal seperator 8.476,11 (correct)
But in Report view in table same number looks like this 8,476.11 (incorrect)
I already changed regional setting and also settings on my PC. Nothing works...
Any idea chow to change it?
Thanks,
Aleks
Hi,
Try using Tabular editor to change the format of the column.
checkout below link for more details.
https://community.powerbi.com/t5/Desktop/Format-string-in-Tabular-Editor-in-Thousands/td-p/1431643
Thanks
Bhuvan
Hello,
Try the SUBSTITUTE Function and replace the "." with "," or vise versa.
Best
look like it works but when i change to text other visualizations collaps...
Any other solution?
BTW what do you mean it's not a number format?
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 |
---|---|
117 | |
101 | |
68 | |
68 | |
43 |
User | Count |
---|---|
146 | |
106 | |
105 | |
90 | |
65 |