cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
czaya2000 Advocate I
Advocate I

Auto formating - prevent language change (K to Tsd in German etc..)

All, 
 
I have the following challenge: 
 
  • The dashboard will be deployed to many locations 
  • I am using autoformating for some numbers in a Matrix
  • This works very well with English (K for thousands, M for millions etc.) 
  • But messes up format in German (TSD) or Danish (tusinnd) etc. 
     
    Is there any way to force it to always display English abbreviation (so K, M etc.) and not adjust to user locale ?
     
    Thanks in advance for your help! 
    Marcin 
  •  
  •  
  •  
6 REPLIES 6
Super User II
Super User II

Re: Auto formating - prevent language change (K to Tsd in German etc..)

Hi. I think I have never try this but there might be a solution. You can try chaging this option in dataset settings in power bi service.image.pnglanguage settings

By default it is in default language, try chaging it to another language.

 

Regards,



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

Happy to help!

LaDataWeb Blog


czaya2000 Advocate I
Advocate I

Re: Auto formating - prevent language change (K to Tsd in German etc..)

Thanks a lot. This will resolve the issue but will require the change to happen on user side. 

czaya2000 Advocate I
Advocate I

Re: Auto formating - prevent language change (K to Tsd in German etc..)

Is there any way to force English on users without the need to change the setting? 

Super User II
Super User II

Re: Auto formating - prevent language change (K to Tsd in German etc..)

I don't think this change is for each user to click. This should change it for a dataset, so every user that checks the report involving the dataset should see the change.

I'm not sure if there is another place to change language.

 

Regards,



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

Happy to help!

LaDataWeb Blog


czaya2000 Advocate I
Advocate I

Re: Auto formating - prevent language change (K to Tsd in German etc..)

You are absolutely right - its enough to change it on my side. Thanks a lot. 

 

Question --> Now it seems to work on Desktop (chrome) but not on Ipad.... 

 

Any idea if there is anything the user needs to do on the Ipad? 

 

Thanks in advance for any help/ 

Super User II
Super User II

Re: Auto formating - prevent language change (K to Tsd in German etc..)

I'm sorry, I have no idea why is that 😞

Try clearing your cache off the app or browser.



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

Happy to help!

LaDataWeb Blog


Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors