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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Table

I am wondering how to set it so it does not show the contents of additional tables UNTIL a row how been selected in the first table?

 

See attached pictures, I would like for the selection to be empty until a selection is made on the first one.

 

Thanks,

Ben
Table11.PNG3.PNGcolumns.

 

Thanks,

Ben

3 REPLIES 3
Anonymous
Not applicable

Thank you for your fast response.  

 

I am thinking it is more of a visual display.  I have two tables.  Ideally I would like it that when you click the first table, only that result shows up, which is currently the case. But when nothing is selected in the first table, it displays all records.

 

Thanks,

Ben

Hi @Anonymous ,

 

Sorry for the questions but this last post is contrary to your initial post.

 

What is the expected result:

  1. When nothing is clicked the second table has all the values (last post you did)
  2. When nothing is clicked no values are presented (first post)
  3. Do you also want this behaviour for the connection between second table and first table?

Check the edit interactions documentation that can help with part of this issue.

 

Regards,

MFelix


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



MFelix
Super User
Super User

Hi @Anonymous ,

 

You need to create a measure and then use it on the tables you want to be blank when it's not blank:

 

Filter Values = 
IF (
    COUNTROWS ( ALLSELECTED ( Table1) ) > 1;
    BLANK();
    1
)

Regards,

MFelix


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.