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.
Is it possible to have a date range on a drillthrough filter. I have a report and added the drillthrough filters. The drill through filters work fine and when I right-click and choose drill through it takes me to the correct report. However, on a column of dates, I would like to be able to choose a date range instead of just one date. Is this possible? If so, how would I do that. I don't want to use month or year. I want the user to be able to just choose particular dates. On the main report I have a date range slicer and set that for a range. The drill through filter doesn't recognize that slicer. I have to choose the date in the table on that report page and I cannot grab a couple of dates. Thanks
Hi @kwilson,
As stretcharm said, currently, it is not available to select a date range in Drill throughs, only a single a value is supported. You could submit your feature quest at ideas page.
Regards,
Yuliana Gu
Drill throughs don't work with date ranges just single values.
Maybe try the February version it has a sync slicer option across multiple page. It might give you a suitable alternative.
I was advised the Global Report Slicer would work and it does. It works having the dates in a filter using a regular slicer. It does not work with a chicletslicer though.
Thanks
Kathy
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |