Forum Discussion

Copper Contributor

Mar 27, 2023

Date Format: Pivot Table vs Source Data

I formatted the date column in the source data how I wanted it, which is month/ year (for example May-2015 or Jun-2022). When I created a pivot table from this data, it reformatted the date to mm/d...

excel

office 365

Ross321

Copper Contributor

Mar 28, 2023

Rodrigo_

Thanks for the instructions. When I get to step 2, there is no "fields" available to select in either the Pivot table or Pivot chart...

SergeiBaklan

Diamond Contributor

Mar 28, 2023

Ross321

That's here

and next

office1460
Copper Contributor
Nov 15, 2023
SergeiBaklan what if you dont have that number format under the field settings
- karri35
  Copper Contributor
  Mar 27, 2024
  office1460 hii is it working date formatting
- SergeiBaklan
  Diamond Contributor
  Nov 16, 2023
  office1460
  
  Perhaps you have texts which looks like date, not dates which are actually (in behind) numbers.
  - AndersTG
    Copper Contributor
    Feb 24, 2025
    Found this, as I'm having the same issue now.
    The solution doesn't work for data from an Analysis Services connection. But, it does work when data is coming from an SQL-table or Excel it self.
    
    Haven't found a solution for my Analysis Services connection yet.
Ross321
Copper Contributor
Mar 29, 2023
Got it, thank you.