Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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)
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |