Control visibility of data in a matrix based on selection in a table

[renewtx]

Hello,

I am just beginning to learn Power BI and I have what I feel like is a very simple use case that I am having issues with.  I have a basic report that displays records from a simple query in a table visual.  In addition I have added a matrix to the same page/report.  What I want is for the matrix to show the details (all columns) for the record that I have selected in my table, similar to the below, and this actually works:

However, what I cannot figure out is, when I first load the screen/report and I have NOT selected any rows yet, I want the matrix to show nothing (or even be hidden).  Currently what happens is the matrix shows ALL records:

How can I control:

1. Visibility of the matrix to start (until a record is selected) 

2. Make sure the matrix only ever shows the values associated with the selected row in the table?

Is there a better way to do this?  I don't want to use drill down (which seems to require separate pages) and I've looked at tooltips, but that probably won't work due to the potential amount of detail information that needs to be displayed)

Thanks

[renewtx · Accepted solution]

Thanks!  That is what I was looking for ... just one more question.  Is there a way to completely hide the matrix?  Currently it still shows the "Index" column ... any way to make that not show if nothing is selected?  I looked at the matrix formatting options and didnt see anything obvious ...

[DataInsights]

@renewtx,

Glad to hear that works. Here's an article that explains how to hide a visual:

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/ 

[renewtx]

This was perfect!  Thanks!

[DataInsights]

@renewtx,

Try this solution.

Create measure:

Matrix Filter = 
IF ( COUNTROWS ( ALLSELECTED ( 'Table' ) ) = 1, 1 )

Add the above measure as a visual filter:

Result: