Forum Discussion

TomH001's avatar
TomH001
Copper Contributor
Feb 23, 2022

Changing the date format in Pivot table (Power Pivot)

I am having trouble changing the date format in the pivot table loaded from Power Pivot. For normal pivot table, I can change the format in "Field setting" - Number Format.

 

The Number Format option is not available in my pivot table, so I changed the date format in Power Pivot, but the changed date format is not reflected in the pivot table. However, when trying to filter the table, I noticed the changed date format is showing, but just not in the Pivot table, which not showing the required format in the chart.

 

Not sure what is the correct way to change the date format.

 

 

 

 

excel

1 Reply

Sort By
  • TomH001's avatar
    TomH001
    Copper Contributor
    Feb 24, 2022

    I found a solution to my problem.

     

    Need to create two additional columns in Power Pivot using:

    • MonthYear = Format(Date, "MMM-YY") 
    • YearMonthNumber = Format(Date, "YYYYMM")

     

    Sort on the MonthYear column with YearMonthNumber

     

Resources