Slicer and dynamic X-axis w/ Column chart

[aBerg]

Hi. 

I have a report with hour (hh:mm) granularity. This report has a column chart and three slicers (year, month and day). I need the column chart to be filtered and the axis X automatically adjust (dynamically) according to the selection of the slicers, as follows:

- when only year is selected in slicer, the X-axis must be the months
- when the year and month is selected in slicer, the X-axis must be the days
- and when the year, month and day is selected in slicer, the X-axis must be the hours (hh:mm)

I could not find a way to do this with data slicers or filters. Could someone help me by showing me a way, please?

Greetings,

Berg

[Anonymous]

@aBerg -

Instead of using slicers, you could put all of those attributes on the axis and drill down.

Cheers!

Nathan

[aBerg]

Hi @Anonymous 

Thanks for your feedback.

Ok, I understand your suggestion, however I would like to filter without the need to use the drill down/up buttons but change according to the selection of slicers.

Greetings,

Berg