Forum Discussion
Conditional Formatting on a text field based on Slicer selections from a separate dataset
Hello, I am trying to "highlight" the background of each item that falls under a specific category of a slicer. The slicer however comes from a separate dataset i.e. the items come from one data...
nandic
Resident Rockstar
Resident RockstarHi Anonymous ,
There are 3 steps:
1) created disconnected table - it will prevent slicer from filtering main list so you will be able to only highlight selected values
2) create measure like this:
SelectedManager = IF(SELECTEDVALUE('Manager (2)'[Manager Name]) = MAX(Manager[Manager Name]),1,0)
*I am using manager slicer in my demo, table Manager is original, table Manager 2 is disconnected table
3) assign background color conditional format based on this measure
Full description and steps: https://stackoverflow.com/questions/59930844/highlighting-with-slicer-power-bi
3) assign background color conditional format based on this measure
Full description and steps: https://stackoverflow.com/questions/59930844/highlighting-with-slicer-power-bi