Buttons and Drill Through

[StoryofData]

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. 

[TomMartens]

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

[TomMartens]

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]

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?