Percent Sign Position

[Anonymous]

Hi all,

I want to change percent sign position. now it is on the left of number, I want to take it the right of number. I changed the both global and file regional settings to united states but it didn't work.

My measures format are Percantage. I don't want to do that by dax because I have tons of measures. I want to change it from global.

I have this

I need this

Regards

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

Power BI Desktop gets its default number and date formatting from the Windows Region settings. You can check or change those settings, if needed.

Whether you download Power BI Desktop or install it from the Windows Store, you can choose a locale for a specific report to be something other than the locale in your version of Power BI Desktop. The locale changes the way Power BI interprets data when it's imported from your data source.

1. In Power BI Desktop, go to File > Options and settings > Options.

2. Under Current file, select Regional Settings.

3. In the Locale for import box, select a different locale.

Besides setting the language for the Power BI Desktop application, you can also set the model language.

1. In Power BI Desktop, go to File > Options and settings > Options.

2. Under Global, select Regional Settings.

3. In the Model language box, select a different language.

For further information, please refer to the following document.

Supported languages and countries/regions for Power BI 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[negi007]

@Anonymous  you can move the % sign either left or right of the value by changing the format of the measure or value. 

To have it on the right hand side, you can change format 

0.00%;-0.00%;0.00%

and to have it on the right side, change the format to below

%0.00;-%0.00;%0.00

[Anonymous]

Hi @negi007& @amitchandak 

As I mentioned before, I have tons of measure (approximetely 100)

I don't want to change all of them one by one

I send the pbix file to one of my colleague before. When she publish the files the percentages looks on right. When I published it looks on left. My colleague left from our company we are unable to publish pbix file from her computer. I have to solve this problem by myself. It might be affected from regional settings but I'm unable to solve that...   
In substance there must be a global settings for this...

[amitchandak]

@Anonymous , check if this format option can help

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings