Forum Discussion
Solved
Change month name language
Hi. I have made some reports with Power BI Desktop (English version) and I added a column in every report with the formula: MonthName = FORMAT( 'date_field'[fecha]; "mmmm" ) This gave me the name o...
Two ways
1. Go to file > options and settings > options > regional setting > select spanish
Save and close it . Then open
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
)
Hello,
For me, best solution to change language for Format function is to change the culture of the tabular model in pbix file.
To do this, you can follow this article on sqlbi : https://www.sqlbi.com/articles/changing-the-culture-of-a-power-bi-desktop-file/.
Thanks to Marco Russo.
It is by far the best solution, unfortunately this is only usable before doing anything else in the file...