Excel Power Pivot: Change Month Names to the Local Language
Question details
The user needs Power Pivot and Data Model month names to display in the computer's local language instead of remaining in English.
- Product
- Microsoft Excel Power Pivot and Data Model
- Device & OS
- not provided
- Scenario
- An Excel workbook containing a Power Pivot Data Model is opened on a computer using Spanish regional settings, and the user wants month names to appear in Spanish.
- Observed behavior
- Month names generated by the Power Pivot Data Model remain in English even when the computer uses Spanish regional settings.
Check whether the month names are generated by a DAX measure, a calculated column, or a calendar table in the Data Model. Also confirm that Power Query is available under Excel's Data tab before creating a replacement calendar table.
Create a Power Query calendar table with localized month names
Use this reliable workaround when the Data Model retains the locale used when it was created and does not respond to regional settings.
A dedicated calendar table lets you store month names explicitly instead of relying on Power Pivot's model locale. Create both a localized month-name column and a numeric month column so reports can sort January through December chronologically.
For Spanish output, use the Spanish locale when adding the month-name column. The exact Power Query command names can vary slightly by Excel version.
In Excel, select Data > Get Data > From Other Sources > Blank Query, or open an existing query from Data > Queries & Connections.
In Power Query, select Home > New Source > Blank Query, open Advanced Editor, and create a date list covering the required reporting period with a List.Dates expression.
Select the date column, choose Add Column > Date > Month > Name of Month, then use the query's locale settings or the Change Type with Locale command to apply Spanish (Spain) or the required Spanish locale.
Choose Add Column > Date > Month > Month, keep the resulting numeric month column, and name the columns clearly, such as Month Name and Month Number.
Select Home > Close & Load To, choose Only Create Connection and Add this data to the Data Model, then use Month Name in PivotTable rows and sort it by Month Number.
Check whether a locale argument is available in DAX FORMAT
Try this only when your Excel version supports a locale argument for DAX FORMAT; Excel support may differ from Power BI.
Move localized spreadsheet reporting to WPS Office
WPS Office is a free, lightweight Microsoft Office alternative for creating and editing compatible .xlsx workbooks. Its familiar spreadsheet interface supports a smooth migration for standard tables, formulas, formatting, and reporting workflows, although it does not reproduce Microsoft Excel Power Pivot Data Models.
- 1. Export standard workbook data: In Excel, select File > Save As and save a copy in the Excel Workbook (*.xlsx) format before opening it in WPS Office.
- 2. Open the workbook in WPS Spreadsheets: Launch WPS Office, choose Spreadsheets, and select Open to import the .xlsx file.
- 3. Create localized month fields: Use WPS Spreadsheets formulas or a prepared calendar table to store the desired month names explicitly, then format and sort the reporting table as needed.

Frequently Asked Questions
Why do Excel Power Pivot month names stay in English?
Power Pivot and Data Model formatting can retain the locale used when the model was created. Changing Windows or Excel regional settings may not change text already generated by the model.
How can I display Spanish month names in an Excel Data Model?
Create a calendar table with Power Query, add a month-name column using a Spanish locale such as Spanish (Spain), load the table to the Data Model, and use that field in the PivotTable.
How do I stop localized month names from sorting alphabetically?
Add a numeric Month Number column from the date, then sort the Month Name field by Month Number or use the numeric column to control the PivotTable order.
Can DAX FORMAT force a Spanish locale in Excel Power Pivot?
Some DAX environments support FORMAT with a third locale_name argument, such as FORMAT([Date], "MMMM", "es-ES"). However, this option is supported in Power BI and may not be available in Excel, so test it in the specific Excel version.
Will changing the computer's regional settings translate existing Power Pivot month names?
Not reliably. Regional settings may affect newly generated values, but Data Model formatting can preserve the source locale. A calendar table with explicitly localized month names is the more dependable solution.




