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

View all the Fabric Data Days sessions on demand. View schedule

Reply
Anonymous
Not applicable

Hiding a filtered table until a row is selected in the main table

Help.

 

I have 2 tables (visuals) in my canvas, both built out of a dataset connected to my model via direct query. Call them table A and B, where A is the main table.

 

Now, selecting a row in A filters the content in B (ie, B will only show the fields for the item selected in A).

 

Clearly, when I launch the report, no row is selected in A (and, afaik, there's no way to preselect a table row in BI), meaning that table B greets you with a bunch of content that may be confusing/misleading until it's filtered by a row selection in A.

 

What I want to do is write a measure that will hide the contents of B until a row is selected in A. 

I've tried the usual stuff like IF ( NOT ( ISFILTERED (tableA[xxx])) , BLANK())) but it doesn't work.

 

Any hints appreciated. Thanks.

 

1 REPLY 1
Arul
Super User
Super User

@Anonymous ,

What is the common key between these two tables?

Can you try the below approach if your requirement matches with that one?

https://community.powerbi.com/t5/Desktop/Select-values-based-on-selection-from-non-related-table/m-p/3152271#M1065013
Thanks,

Arul





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

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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