Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Slicer and dynamic X-axis w/ Column chart

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

 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Anonymous -

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

    Cheers!

    Nathan

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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