• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date format in a slicer

Hi RafaelAngel,

Slicer is depend on Pivot table fields, so you can group by / format your filed in pivot table and it will automatically visible in slicer.



RafaelAngel said:
Hi,
Can someone tell me how to format a date field in a slicer so you can see July 2016 instead of 07/31/2016?

Thanks in advance.

Reply
Click to expand...
 
Hi ,

A slicer shows all the items in the data ; thus if you have multiple data for different dates in a month , one way is to add a field to your raw data , with the formula :

=TEXT(datefield , "mmmm yyyy")

and then use this new field in your slicer.

However , doing just this will not sort the slicer items in calendar order ; for this , refer to this link , and within the link , the comment by Roger Govier.

http://www.myonlinetraininghub.com/create-a-single-excel-slicer-for-year-and-month

Narayan
 
NARAYANK991 said:
Hi ,

A slicer shows all the items in the data ; thus if you have multiple data for different dates in a month , one way is to add a field to your raw data , with the formula :

=TEXT(datefield , "mmmm yyyy")

and then use this new field in your slicer.

However , doing just this will not sort the slicer items in calendar order ; for this , refer to this link , and within the link , the comment by Roger Govier.

http://www.myonlinetraininghub.com/create-a-single-excel-slicer-for-year-and-month

Narayan
Click to expand...

Thanks, xlstime and NARAYANK991. I finally decided to use the Timeline filter

upload_2016-9-10_12-55-12.png

as date format didn't work when using related tables.
 
You must log in or register to reply here.
Back
Top