Forum Discussion
Buttons and Drill Through
Hi,
I need to show all cities in a table format and then have an option for a city summary on a separate page. I've achieved that through Drill Through. Is this the most efficient way to solve this problem?
My hesistation with using Drill Through is the extra options that appear on the menu - Show as a table, Include, Exclude, etc.
3 Replies
- TomMartens
Super User
Hey StoryofData ,
the simple answer is - yes this is the most efficient way to pass a single city to another report page showing details of the selected city.
A different approach is to provide the detail information as a report page tooltip: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips?tabs=powerbi-desktop
I consider a report page tooltip a more intuitive means to present detail information to a selected element, because it appears on mouse-over. On the other hand, interactivity with the report page is limited.
Hopefully, this helps to tackle your challenge.Regards,
Tom
- StoryofData
Helper III
Tooltip might actually be intersting to use as a quick view but I still a separate page for each city, I appreaciate the tip though!
Any way to achieve this through buttons maybe?
- TomMartens
Super User
Hey StoryofData ,
maybe you are looking for conditional drillthrough/page navigation, this page shows an example: https://visualbi.com/blogs/microsoft/powerbi/conditionally-drill-action-power-bi/
Regards,
Tom