Power pivot table Date

J

jakobt

Active Member
Joined
May 31, 2010
Messages
337
I draw a date field to my pivot table. However 3 fields are added automatically in the pivot: year, month and Quarter.

How can I amend so only the date field is added it with same format as field in underlying table: YYYY-MM-DD
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
Sort by date Sort by votes
To get just the date field you need to Ungroup the Date.
  • Select any of the dates in a table
  • Right click and select ungroup
  • OR go to the menu PivotTable Analyze > Ungroup
Once you have ungrouped you can format the date field.
  • Right click on the any of the dates
  • Field Settings > Number format > Choose your format or create a custom one
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
Indentations for Pivot table Rows fields
Replies
5
Views
240
Alex Blakenburg
A
M
  • Question
Mutiple pivot table dates dropdown
Replies
0
Views
157
mukesh a
M
W
  • Question
Calculated Field
Replies
4
Views
101
Alex Blakenburg
A
W
  • Question
Making me CRAZY!
Replies
3
Views
137
bobsan42
bobsan42
D
  • Question
Calculated Field in Pivot
Replies
2
Views
355
daveyc18
D

Forum statistics

Threads
1,215,759
Messages
6,126,728
Members
449,332
Latest member
nokoloina

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top