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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors