Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
svp1000
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION
v-jiewu-msft
Community Support
Community Support

Hi @svp1000 ,

Based on my testing, please try the following methods:

1.Create the sample table.

vjiewumsft_0-1721267820884.png

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.

vjiewumsft_1-1721267833448.png

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

vjiewumsft_2-1721267849416.png

 

vjiewumsft_3-1721267855531.png

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.

 

 

 

 

View solution in original post

5 REPLIES 5
v-jiewu-msft
Community Support
Community Support

Hi @svp1000 ,

Based on my testing, please try the following methods:

1.Create the sample table.

vjiewumsft_0-1721267820884.png

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.

vjiewumsft_1-1721267833448.png

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

vjiewumsft_2-1721267849416.png

 

vjiewumsft_3-1721267855531.png

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.

 

 

 

 

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

amitchandak
Super User
Super User

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

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

svp1000_0-1721253383839.png

Now the visualizations look like this

svp1000_1-1721253461823.png

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_2-1721253708571.png

 

svp1000_3-1721253777317.png

 

 

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.