Forum Discussion
Drill through alternative?
I have a page with a table of peoples details and then you can click a row and drill through to another page that is like a profile and shows their details, but on that page I have a scatter plot that gets filtered to only show that person, I want to show them amongst everyone else like highlighted, from what I can see drill throug filters all visuals on the page and you can't change that ? Is there an alternative way I should be attempting this? Thanks
Hi Anonymous -you can use bookmarks and selection controls functionality. as an another approach involves creating a setup where clicking a table row sets a filter or highlight without using the traditional drill-through that affects all visuals on the page.
Reference links : hope it helps
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
Solved: How to use Bookmarks on the same page ? - Microsoft Fabric Community
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.mssqltips.com/sqlservertip/5910/power-bi-drill-through-example/
https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Below are the alterantives of drill down
1) Use a parameter to control the highlighting2) Use bookmarks and buttons
3) Use a custom visual with a custom visual interaction
4) Use Visual-Level Filters with DAX
2 Replies
- rajendraongole1
Super User
Hi Anonymous -you can use bookmarks and selection controls functionality. as an another approach involves creating a setup where clicking a table row sets a filter or highlight without using the traditional drill-through that affects all visuals on the page.
Reference links : hope it helps
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Learn
Solved: How to use Bookmarks on the same page ? - Microsoft Fabric Community
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.mssqltips.com/sqlservertip/5910/power-bi-drill-through-example/
https://docs.microsoft.com/en-us/power-bi/desktop-cross-report-drill-through
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!! - elitesmitpatel
Solution Supplier
Below are the alterantives of drill down
1) Use a parameter to control the highlighting2) Use bookmarks and buttons
3) Use a custom visual with a custom visual interaction
4) Use Visual-Level Filters with DAX