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
Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Microsoft Ignite 768x460.png

Find your focus

Explore the latest tools,training sessions,technical expertise, networking and more.

Power BI Womens Summit 2021 768 x460.jpg

Interviews, learning sessions, allies, and more!

#PowerBIWomenSummit

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!