Forum Discussion

hectormungo's avatar
hectormungo
Frequent Visitor
9 years ago
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...
Need Help
  • Baskar's avatar
    Baskar
    9 years ago

    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

     

    )

     

     

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

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

 

)