Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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?
Solved! Go to 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.
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.
this worked for me! all I had to do was to remove the ID from the bottom table and it works as expected
@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
@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
@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?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
123 | |
107 | |
61 | |
55 |