Forum Discussion
Helper IIAlways use the default regional settings
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
Helper IIHi Anonymous
Please refer again to my first 2 posts. But in short, the "Additional settings..." in regional settings are ignored in most cases. If I want to keep "Français (Canada)" as the format but want to show, as an example, currency as "English (United States)" using the dot (".") for "Decimal symbol", I can't.
Thank you
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
- Jonathan_P
Ok thanks Anonymous!