This one had me puzzled for a while. I'm using a MySQL database connected to excel pivots. for the purpose of utilizing slicers to easily analyze my data, I put in the database columns specifying: Year, Month, Day, Hour, Minute, of the actual event.

now, lets say for example I want to select the data from start of January to mid-February.

It looks pretty impossible by using these slicers, since when I'm clicking the 1st to the 15th in the day slicer, I'm actually disabling the rest of January from appearing in the chart display.

I hope I'm doing something wrong and there's an easy way to make this more effective.

Many thanks for any kind assistance,