Can't change default language

[Anonymous]

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

[amitchandak]

@Anonymous , refer

https://www.powerbi-pro.com/en/creating-multilingual-reports-in-power-bi/
https://community.powerbi.com/t5/Desktop/How-to-create-Multilingual-Report-in-Power-BI/td-p/599696
https://www.youtube.com/watch?v=JJryD2dXVVw

Or

https://docs.microsoft.com/en-us/power-bi/fundamentals/supported-languages-countries-regions

[harshnathani · Accepted solution]

Hi @Anonymous ,

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)

[Anonymous]

Hi @harshnathani, 

This worked. Thanks a lot!!