The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
1) I've one page where i am displaying the data in a table. If i select one item(workstream) in the table and click on the "View details" Button, which is a drill through button it will take me to the "Detailed view_FY25" page
2) In the "Detailed view_FY25" page the workstream is getting filtered based on the drill through filter from "Report View".
in the same page i've added 2 bookmarks, Expenses(Test 1) and Pending invoice(Test 2).
Now the problem is that if i navigate between these 2 bookmarks then the drillthrough filter is not working.
Pending invoice bookmark:
Expenses bookmark:
Is there any way where i can preserve the drill through filter from "Report View" Page in "Detailed view_FY25" page while switching between those 2 bookmarks.
Solved! Go to Solution.
Hi,
It's resolved.
If we disable the data of that bookmark, then we can preserve that drilltrough while switching between those bookmarks.
Probably not, and you are probably overcomplicating things. Is this something your business users have asked for?
Note that bookmarks in Power BI Desktop can be selective on what they capture. You can experiment with those settings to see if that gets you any closer. Also note that you can semi-ignore drillthrough filters by using shadow copies of your tables.
Hi @lbendlin ,
Yes, i need to preserve that drill through filter in "Detailed View_FY25" page while switching between those two bookmarks.As you can see in the selection pane, i am hiding the visuals using bookmarks while keeping the drillthrough filter. Is there any other way i can achieve this?
I don't think that's a meaningful user experience. I hope someone else can help you further.
Hi,
It's resolved.
If we disable the data of that bookmark, then we can preserve that drilltrough while switching between those bookmarks.