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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.

Top Solution Authors
Top Kudoed Authors