create filter from a table

Question

Hi,&nbsp;I have a main page with :- filter slicers- a matrix with a list of all the projects with details of budgets, actuals, etc- a navigation button that navigates to further details of every project&nbsp;When you click on a project in the table, it filters the main page. However, when you then click on the navigation button, I would like to keep the context of my selected project from the matrix as now it ofcourse only filters based on the slicers.&nbsp;Any idea how to fix it?&nbsp;Regards

pablodeheza · Answer

Hi&nbsp;Anonymous&nbsp;!Have you tried using the Drill Through feature?
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through?tabs=powerbi-desktopLet me know if that helps!

anonymous · Answer

Hi Pablo,&nbsp;Thanks that helped quite a bit.That seems to work , but now when I don't select a project I can not go any longer to the detailed report anymore. Is there a fix for that?&nbsp;&nbsp;

anonymous · Answer

anybody that could support? 🙂

pablodeheza · Answer

Hey,
How are you setting up that button exactly?

anonymous · Answer

I have 2 tabs :1 main report1 detailed tab&nbsp;&nbsp;In the detailed tab I have my drillthrough settings as followed :&nbsp;&nbsp;The button on the main tab is set up as followed :&nbsp;&nbsp;&nbsp;

Forum Discussion

create filter from a table

6 Replies

Related content

Create new table

Lakehouse Table Generate Create Table

Filtered table

Create rows from 2 tables

Creating a dynamic filtered table variable