drill through filters

Question

Is it possible to have a date range on a drillthrough filter.&nbsp; I have a report and added the drillthrough filters.&nbsp; The drill through filters work fine and when I right-click and choose drill through it takes me to the correct report.&nbsp; &nbsp;However, on a column of dates, I would like to be able to choose a date range instead of just one date.&nbsp; Is this possible?&nbsp; If so, how would I do that.&nbsp; I don't want to use month or year.&nbsp; I want the user to be able to just choose particular dates.&nbsp; On the main report I have a date range slicer and set that for a range.&nbsp; The drill through filter doesn't recognize that slicer.&nbsp; I have to choose the date in the table on that report page and I cannot grab a couple of dates.&nbsp; Thanks

stretcharm · Answer

Drill&nbsp;throughs don't work with date ranges just single values.&nbsp;Maybe try the&nbsp;February version it has a sync slicer option across multiple page. It might give you a suitable alternative.&nbsp;

kwilson · Answer

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

v-yulgu-msft · Answer

Hi&nbsp;kwilson,
&nbsp;
As&nbsp;stretcharm said, currently, it is not available to select a date range in&nbsp;Drill&nbsp;throughs, only a single a value is supported. You could submit your feature quest at ideas page.
&nbsp;
Regards,
Yuliana Gu

kwilson · Answer

Spoiler (Highlight to read)Actually, the Global Filtering took care of my issue.&nbsp; The only issue is that Global filtering does not work on the chiclet slicer filter.&nbsp; It works on the regular "Slicer" and if you use a date field on the regular slicer it works nice as a Global Filter.&nbsp; ThanksActually, the Global Filtering took care of my issue.&nbsp; The only issue is that Global filtering does not work on the chiclet slicer filter.&nbsp; It works on the regular "Slicer" and if you use a date field on the regular slicer it works nice as a Global Filter.&nbsp; Thanks

Forum Discussion

drill through filters

4 Replies

Related content

Removing Drill Down Filters

Remove drill through filters

Drill Through

Omit filter from drill through

Drill Through - Keep all filters but Ignore Financial Year Slicer Filter