Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Jorr13
Frequent Visitor

Drill Through - Keep all filters but Ignore Date Filter

Is there a way to "keep all filters" except ignore a date filter? I have multiple date frames by visual type on my "Drill To" tab. For example, I have a relative date slicer for "Last 1 Week" on my Matrix visuals and I have Line Graphs which show sales/inventory by week over the last 3 years. To accomlish this, I am using the Edit Interaction feature which I "block" the Date Slicer interaction to my Line Graphs. The problem that I have is that when I Drill-Through, my date filter on the "Drill From" page is overiding my Line Graphs to "Last 1 Week" which only results in 1 week of sales data (which isn't very useful.) I do want some of the drill-though filters to "stick" (such as category, manufacturer, etc.) I'm even okay with the date filter to follow, I just don't want the date from my drill from page to overide my date frames on my line graphs. I do publish my reports so, deleting the drill-through filter after drill-though will not work. Please let me know if anyone has a solution to this. I appreciate any help you can provide! Thank you!

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Jorr13 , if you uncheck "Keep all filter", and whatever you keep below that will pass. I think that is way to control what you can pass

 

Power BI Drill Through - More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk

View solution in original post

2 REPLIES 2
Sweeney1987
New Member

Worked like a charm. Thank you!

amitchandak
Super User
Super User

@Jorr13 , if you uncheck "Keep all filter", and whatever you keep below that will pass. I think that is way to control what you can pass

 

Power BI Drill Through - More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.