navigation between pagination report

[h_e_m_a_1]

I have one report where I have one column in which calculated values are there for eg.there is list of songs with artists and in one column I have count of artist like there 2 songs for artist 1 and 4 songs for artist2 and so on, when I click on specific cell/count, I want to get all columns details for that count details on another page like artist details,songs details and other coulmn which are related to that artist for that counts record/entry. Is there a way to navigate to a different sheet when a user clicks on a specific calculated cell in the table/cell details? Selecting an cell should apply that cell as a filter and navigate the user to a different sheet, where I can show more information about that selected cell instead of showing everything in a table/report.

[MFelix · Accepted solution]

Hi @h_e_m_a_1 ,

For this you need to use the Drilltrough experience.

Check this link with all the information you need to setup, if you have any question please let me know.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

[h_e_m_a_1]

Hi MFelix,

For above question I go through link provided by you. I used Cross-drillthrough option by providing some settings on both reports (Summary page and details page). It worked. 😊

Thank you so much for the help !!