Too much data on Table Visualization... How can I click a row and show one record?

[jamiers]

I have a table that has too much data in it, but all of the data is needed.  How can I click one row and get it to show a page that has that one row's data?

[PaulDBrown]

@jamiers 

An alternative to @Greg_Deckler  solution is to create a report page tooltip which triggers when you hover on a row. Check out these videos:

[Greg_Deckler]

@jamiers You could use Drillthrough. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

[jamiers]

@Greg_Deckler I can't mark this as a solution, because I don't understand the linked page or it is not showing what I need to do.  Thanks anyway.

[Greg_Deckler]

@jamiers  I mocked this up for you in the attached PBIX file below sig. You want Page 14. On the table, right-click any row. Choose drillthroug and then Page 14a. You will be presented with that row's and only that row's data. Use the back button in the upper left to navigate back (Ctrl-Left Click)