cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jamiers
Regular Visitor

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

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?

4 REPLIES 4
PaulDBrown
Super User II
Super User II

@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:

 

 

 





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Greg_Deckler
Super User IV
Super User IV

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




@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.

@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)

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors