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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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