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
Hi Jonathan_P,
That how Power BI Desktop reports display numbers and currency has nothing to do with the system Regional setting as shown in your screenshot. In Power BI Desktop, if you want to format your numbers, please perform the following steps.
1. Click your column in the Fields panel of the following screenshot, then click on Modeling in the Desktop ribbon, select Thousands operator and set Decimal places to 2.
2. Change the format to Currency>$ French(Canada), the positive and negative values will display in your desired format.
Thanks,
Lydia Zhang
Helper IIHi Anonymous,
First, I want to clarify. Again, I have selected "Français (Canada)" as the format in my system regional settings and this is fine for me. I just wanted to show temporary the values differently on the reports and as the "English (United States)" format's default. So I customized "Français (Canada)" and changed the decimal and the digit grouping symbols respectively to "." and ",". I restarted Power BI Desktop and saw that it had no impact on the reports. Then I found that selecting "English (United States)" as the format worked. I am concluding that Power BI Desktop use the format's default settings only. So the reports display has something to do with the regional settings set on Windows. However, maybe that this behaviour is by-design.
On the step 1 you provided, that only indicates how the values of a column are displayed:
1) If it displays the thousands separator or not. So, the format's default "Digit grouping symbol" from the regional settings is used here.
2) How many decimal places are displayed. Interestingly, here the default is taken from the customized regional settings value (as opposed to the decimal and the digit grouping symbols).
On the step 2, I agree that it's useful. But in my particular report I chose "$ English (United States)" and it's fine.
Thank you
Hi Jonathan_P,
I re-test the scenario as yours. When I firstly create a table visual using sample data in figure 1.
figure 1
The table visual looks like as shown in figure 2.
figure 2
When I selected "Français (Canada)" as the format , changed the decimal and the digit grouping symbols as yours, the visual displayed is shown in figure 3.
figure 3
When I changed it back to English (United States), I also tried to changed the decimal in this case, the table visual is still same as figure 2. Thus, I recommend you directly format your columns using modeling tab in Power BI Desktop rather than using system regional settings becuase the customized formats for number and currency in English (United States) or Français (Canada) are both ignored.
Thanks,
Lydia Zhang- Jonathan_P
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...
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