Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
BRIANCC
Frequent Visitor

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

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!

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

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

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

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!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.