Forum Discussion

sbsgsaw1's avatar
sbsgsaw1
Frequent Visitor
5 years ago
Solved

Conditionally colour Column based on Slicer Selection

Hi i may be coming at this all wrong but here goes, i have a dashboard of staff performance where the visuals are set by the selection of a name, in most cases this means that visuals only contain ...
  • lbendlin's avatar
    lbendlin
    5 years ago

    Table2 is the disconnected table that feeds the slicer. You can create it in Power Query as a duplicate of Table, then choose the User column and remove duplicates.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

sbsgsaw1 use a disconnected table to feed the user slicer.  Then create a measure that checks which user is selected and apply the color accordingly

 

Measure = if(SELECTEDVALUE('Table'[User])=SELECTEDVALUE('Table (2)'[User]),"Red","Blue")

 

Then use conditional formatting on the data colors for the visual

 

Which gives this result