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
No, I can't use the modeling tab to format columns completely. There is no way to change decimal and digit grouping symbols. Maybe I'm missing something...
Hi Jonathan_P,
Thanks for sharing me the PBIX file. Could you please describe more details about how you want to format columns in modeling tab and change decimal, digit grouping symbols in Power BI Desktop?
I make a test in your PBIX file, I can select Thousands operator and set Decimal places to different values for columns such as YTD sales. You can check the following screenshot.
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!