Forum Discussion

Jonathan_P's avatar
Jonathan_P
Icon for Helper II rankHelper II
9 years ago
Solved

Always use the default regional settings

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...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
Jonathan_P
Icon for Helper II rankHelper II
9 years ago

Ok thanks Anonymous!