Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
68 | |
54 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |