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.
I have what I think is a simple...ish problem. I have a report built to display machine downtime data. I have a slicer to filter the graphs by month with 12 selectable options (Jan-Dec) along the top. I then have a day slicer underneath that, to drill down to a specific day. Is there an easy way to have the day slicer react to the month slicer? For example, today is December 9th and there is obviously no data for days 10-31, how can I get the day slicer to only show 1-9?
Thanks,
Rob
Hi @robandemmy ,
Assuming you have a seperate date table, you could create a column called IsBeforeToday then filter the day slicer to IsBeforeToday=True.
Something like this:
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |