Hi,
I've got a timeline slicer controlling visible dates in my pivot chart
At the moment the only records are in September, but the timeline slicer shows a range of every month in the year, like this:
How can I get it to show only the available range - i.e. from the earliest to latest months?
(recognising that in the timeline above if "months" were selected it would only show "SEP")
I've got a timeline slicer controlling visible dates in my pivot chart
At the moment the only records are in September, but the timeline slicer shows a range of every month in the year, like this:
How can I get it to show only the available range - i.e. from the earliest to latest months?
(recognising that in the timeline above if "months" were selected it would only show "SEP")
