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

PowerBI Urgent help

In my Dashboard there are 4 table visuals ( A,B,C,D). Hierarchy order is A->B->C->D

 

A-->B  1-Many Relationship

B-->C  1-Many Relationship

C-->D  1-Many Relationship

 

In Table Visual A I clicked on particular row then Table visual B is filtered, If I click on particular column in B then Table visual C is filtered & If I clik on particular row in Table visual C, Table visual D is filtered.  Now the problem is I am not able to see which rows I clicked on each table. Since this is a hierarchy order I want to see the each row (which I clicked on).  Someone please help me with this.

 

Note: Requrement from client is such that I cannot use slicers/filters for this. The above is the exact requirement

 

1 REPLY 1
crispybits77
Helper I
Helper I

I'm not at a computer with Power BI on it right now (on my tablet on the train) but I think you could do this with a measure to either display in a column on the table or to choange the colour of one of the columns (so leave it default for anything that isn't selected and give it a colour if that row is selected.

The measure would look something like IF(Table[Value]=SELECTEDVALUE(Table[Value]), "do something", "do something else") but as I say I don't have PBI right now and I'm not good enough at DAX to write that kinda thing off the top of my head so there will probably be a complication I'm not considering (maybe you'll have to add in an IF(ISFILTERED... too)

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!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.