Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 clic...
Need Help
crispybits77's avatar
crispybits77
Icon for Helper I rankHelper I
2 years ago

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)