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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

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

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors