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,

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

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

Yes, I click on the column in the Fields panel before going to the modeling tab.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Jonathan_P,


    What is your data source? How do you connect to the data source in Power BI Desktop? Please help to post the screenshots of your scenario.

    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