Bottom table should only show based on top table selection otherwise I want it to show blank

[svp1000]

Hi All,

I have a visual table at the top and visual table at the bottom.

The top table has the ID, Name, etc and when I click on it, I want the bottom table to show the corresponding Review comment (which is on the same data table but I want to show it separately in the bottom table).

It works currently but the issue I am facing is that when nothing in the top table is selected (where it shows all the data), it shows all the Review comments in the bottom table but i want it to be blank until something is selected in the top table.

Is there a way to do this?

[v-jiewu-msft · Accepted solution]

Hi @svp1000 ,

Based on my testing, please try the following methods:

1.Create the sample table.

2.Create the new measure to filter the table.

IsSelected = IF(ISFILTERED('Table'[ID]), 1, BLANK())

3.Drag the measure into the bottom table Filters pane.

4.Drag the comment field into the bottom table. The result is shown below.

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[svp1000]

this worked for me! all I had to do was to remove the ID from the bottom table and it works as expected

[amitchandak]

@svp1000 , You can create a measure using isfiltered on group by(Non Sumamrized column) and use that as visual level filter for second table

if(isfiltered (Table[Brand]), [Measure], blank())

Use in visual filter on the second table and check that is not blank

Refer video from Guyinacube

https://www.youtube.com/watch?v=sXn-QZqLD-8

[svp1000]

@amitchandak in order to create a more clearer picture, I will attach some screenshots from an example. My underlying data table looks like this - 

Now the visualizations look like this

I created a measure like you mentioned and applied it to the bottom table filter but it is still shows up all the rows

[svp1000]

@amitchandak  - when i create such a measure, it doesn't turn blank for all the non selected rows and is showing up as the ID for that particular row, and so is still showing up all the rows in the bottom table.

basically the top table is aggregated already on amount and other fields. is this a problem?