cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shubhy04
Helper I
Helper I

Can't change default language

Hi, 

 

I got one .pbix file from a source based out out of germany with German as the default language showing up in dashboard ("Mar" month showing as "Mrz"). I have already tried changing the default language to English(India) under

 

1) File>Options & Settings> Options>Regional Settings> Locale for Import

2) File>Options & Settings> Options>Regional Settings> Application Language/Model Language

 

It still not changing to English with any of the options. Is there any other i'm missing? Kindly suggest.

 

Thanks

Shubham

1 ACCEPTED SOLUTION
harshnathani
Super User
Super User

Hi @shubhy04 ,

 

Did you save. Close the file and Open again.

 

if it will not help u . U have to create one calculated column to replace the old column with same name.

 

 

Column = var Month_Name = FORMAT( 'date_field'[fecha]; "mm" )

 

return switch ( true(),

Month_Name=1, "Jan in Spanish"

.

.

.

etc

 

)

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

View solution in original post

3 REPLIES 3
harshnathani
Super User
Super User

Hi @shubhy04 ,

 

Did you save. Close the file and Open again.

 

if it will not help u . U have to create one calculated column to replace the old column with same name.

 

 

Column = var Month_Name = FORMAT( 'date_field'[fecha]; "mm" )

 

return switch ( true(),

Month_Name=1, "Jan in Spanish"

.

.

.

etc

 

)

 

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

View solution in original post

Hi @harshnathani

 

This worked. Thanks a lot!!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.