Forum Discussion
drill through filters
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
The February version added a very long requested feature. This is the ability to have a slicer on one page filter data on another page.
Check it out here
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/#syncSlicers
3 Replies
- Phil_Seamark
Microsoft Employee
Hi kwilson
What version of Power BI Desktop are you using? Have you played with the new Global report slicer setting? This will allow you to use a slicer to control data on other pages.
What are the kind of date ranges you like to work with? Another option is to create groupings in your tables.
Power BI Desktop Version 2.55.5010.581. Date Range could be a little as two days or as large as a month or two.
Not sure what the "Global report slicer setting is? I have to look that up.
Thanks
- Phil_Seamark
The February version added a very long requested feature. This is the ability to have a slicer on one page filter data on another page.
Check it out here
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2018-feature-summary/#syncSlicers
