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

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

It's ignored. Is it by-design?

 

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...

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Jonathan_P,

I haven't found any official information about if it is by-design. I will report this issue internally and post back once I get any updates.

In addition, could you please describe more details about that how you format the columns in Power BI Desktop? Do you click the column in Fields panel before you go to modeling tab?

Thanks,
Lydia Zhang