How can I set English as a default display language for every report users?

[BRIANCC]

Hi community,

I am building a Power BI report to be shared with the business leaders.

I'm wondering if anyone can help me to set English as a default display language regardless of each business leader's browser language.

I designed the report optimized with the English view, and the problem is that the report design wrecks when the users using different local language see the report. (i.e. the numerical unit 'M (million)' is displayed in their local language and the design becomes little mess)

I know that each user can go to the settings and change the display language, but I'd like to simply set the default display language as English.

Thank you for your help in advance!

[Ritaf1983 · Accepted solution]

Hi @BRIANCC 
If the issue is just a numbers you can resolve it with dynamic string formatting.

https://www.youtube.com/watch?v=N11LneTF8-4

If it is deeper and includes dates formats and others, there is no way to ignore the browser language unfortunately

There is an idea about this issue, please vote for it : (i voted 🙂 )
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=3ac7e34d-922a-ec11-b76a-281878bd589b

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

[BRIANCC]

YES, the number unit was the biggest issue in this matter.

I could solve the problem with the dynamic string format you've introduced.

Much thanks to you!