When I try to put in a timeline slicer to my pivot table, it is showing more months than there is data.
The months in my Data are between Nov '14 and April '15 but I have months showing from January '14 all the way till Dec '15.
I've confirmed there are nothing in the other months by selecting them all and they return no data in the pivot table.
Please help.
Right click slicer and use Slicer settings to hide items with no data
I have Slicer settings in a regular slicer, but not in the timeline. If I did, this wouldn't be a problem.
I think the timeline slicer only does timelines. Whay you have is categories with date like description
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks