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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!