Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to Solution.
@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
Worked like a charm. Thank you!
@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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
140 | |
71 | |
64 | |
52 | |
50 |
User | Count |
---|---|
209 | |
92 | |
64 | |
59 | |
56 |