Need default value in slicer along with drill through value in table visual

[Anonymous]

I have 2 pages 1 page is having material No column and other page is having material details based on the material number from 1st page, via drill through feature.

I have scenario like on 2nd page user is select material no "4" on page 1 table visual and drill through to the material details page can able to see the data based on level 1 by default. below  is the screenshot for reference.

And another scenario is, in the same page I need create a button that will reset the default selection.(This I can able to achieve with the help of a button on giving the action as "clear all filters" it will clears the all slicers on drill through page). below is the screenshot for reference.

but the problem is how to set a default level 1 selection in page 2 that will give details based on the selected material number from the table on page1.

Could someone please help me on this scenario that will really helpful to me.

Thank you so much in advance

[Anonymous]

No

[foodd]

Hello @Anonymous , and thank you for sharing a question with the Community.  This reply is informational.  Please remember to adhere to the decorum of the Community Forum when asking a question.

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot). You can upload the PBIX file to a cloud storage service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share a file’s URL.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523/highlight/true#M607150

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!