Formatting Issues

Excel Power Pivot: Change Month Names to the Local Language

Steven ParkerSteven Parker Nov 12, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open Power Query

In Excel, select Data > Get Data > From Other Sources > Blank Query, or open an existing query from Data > Queries & Connections.

2
Create a date list

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.

3
Add a Spanish month name

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.

4
Add a month number

Choose Add Column > Date > Month > Month, keep the resulting numeric month column, and name the columns clearly, such as Month Name and Month Number.

5
Load the table to the Data Model

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.

Use Month Number for sorting: If the localized month names sort alphabetically, select the Month Name field and configure the report or model to sort it by the numeric Month Number field.
Free Microsoft Office alternative

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. 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. 2. Open the workbook in WPS Spreadsheets: Launch WPS Office, choose Spreadsheets, and select Open to import the .xlsx file.
  3. 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.
Free and lightweight spreadsheet software for everyday reporting and workbook editingFamiliar interface that helps Excel users migrate with minimal retrainingCompatible with Microsoft Excel .xlsx files for sharing and continued editingUseful for localized month-name tables, date formulas, and standard spreadsheet formatting
microsoft office alternative - wps office

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.