Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
h_e_m_a_1
New Member

navigation between pagination report

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.

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
MFelix
Super User
Super User

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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 !!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.