Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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
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)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 37 | |
| 28 | |
| 28 |
| User | Count |
|---|---|
| 124 | |
| 89 | |
| 73 | |
| 66 | |
| 65 |