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,
First of all, this is my first post ever here. So, hello community!
I found that Power BI Desktop always use the default regional settings for the selected format on the report display. If those settings are customized, they are ignored, at least for the numbers and currency. In my case, I selected "Français (Canada)" as the format but changed the decimal and the digit grouping symbols. See the screenshoot.
Thank you
Solved! Go to Solution.
Hi @Jonathan_P,
As you want to keep "Français (Canada)" as the format on system regional setting and want to show currency as "English (United States)" in Power BI Desktop. You can use Format function to change its format, I test it successful using your PBIX file.
Just maks some changes to your measures, for example:
YTD Sales = FORMAT(TOTALYTD([Total Sales]; 'Date'[Date]);"Currency")
LY Sales = FORMAT( CALCULATE([Total Sales]; SAMEPERIODLASTYEAR('Date'[Date])); "Currency")
Sales Var = FORMAT(( [Total Sales] - [LY Sales]);"Currency")
Thanks,
Lydia Zhang
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |