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 everyone
I have created a report in Power BI Desktop. It is not linked to Service.
When i created the report i set the regional settings (local file) to danish, so the number and date format would be correct, but for some reason the format is only correct in the query editor and data view. When I create a visual (table), it shows the numberformat as an american format.
I have Windows 10 on my computer, if that can affect the problem somehow. My regional settings in windows is set to danish as well.
Datasource is an azure sql-server database.
I hope you guys can help me, thanks in advance
EDIT - SOLUTION:
It was the Windows region settings making the mess. It was set to "English (Denmark)" before and after I changed it to "Danish (Denmark)" PBI Desktop formatted correctly after a restart.
Solved! Go to Solution.
It was the Windows region settings making the mess. It was set to "English (Denmark)" before and after I changed it to "Danish (Denmark)" PBI Desktop formatted correctly after a restart.
It was the Windows region settings making the mess. It was set to "English (Denmark)" before and after I changed it to "Danish (Denmark)" PBI Desktop formatted correctly after a restart.
Hi MSA-SOJ,
Could you please share the screenshot to us for analysis?
Generally, the number format displayed in visual should be same in model, please try to change it in Modeling -> Formatting.
Best Regards,
Teige
Hi Teige
Thanks for replying
Here is a number of screenshots of my data, and what i have tried since i submitted the question:
My numbers in query editor - the data is shown and the only steps made are source and navigation:
Here my numbers have a comma for decimals, which is what i want.
The the data view my numbers is also have commas for decimals.
The the report view in my visuals the numbers are formattet american and have a dot for the decimals. The modelling > formatting is greyed out here.
The things i have tried includes:
Format the numbers as text in query editor and using DAX VALUE() to correct it - still american format
Using DAX FORMAT() - kinda worked as i had commas, but formattede my numbers as text, which ruined the aggregating functions and removed the totals in my visuals.
Formatting numbers as danish currency using modeling > formatting - still american format in visuals.
I hope this i enough information for you to help me better.
Thank you alot
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |