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

I don't know which screenshots to provide. The data source is an Access database. This is one of the data source used for the course on edX.org web site here. The lab in particular is Lab 2. This is not a real-life case. I just found that this was maybe a bug or wanted to ask if it was by-design. I wanted to understand it. The question was raised when I exported the data in csv.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Jonathan_P，


Do you import CSV file or Access database to Power BI Desktop and then format the column?  Would you mind sharing me the PBIX file or data source? I will test it in my Desktop.

Thanks,
Lydia Zhang