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?
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
210 | |
49 | |
45 | |
44 | |
42 |
User | Count |
---|---|
262 | |
211 | |
103 | |
79 | |
65 |