Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
@aBerg -
Instead of using slicers, you could put all of those attributes on the axis and drill down.
Cheers!
Nathan
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |