Forum Discussion
Solved
Conditional formatting on table visual based on slicer selection
I have a table visual with a column for employee names and several columns for area access I have slicers for each of those areas and I would like to be able to highlight/fill the column only when an...
Yes. You would create a table for each slicer
wc =
Distinct( table[WC])
Then you would create a measure used for the conditional highlighting for that column
If(
selectedvalue( WC[WC]) = selectedvalue( table[WC], "#ff00ff" )
You would do this for each column
Made this measure that seems to work better with multiple items selected in a slicer/slicers.
IF(ISFILTERED(WC[WC]) && COUNTROWS(INTERSECT(VALUES(WC[WC]),VALUES(table[WC]))) > 0,"#color","transparent")
Yes. You would create a table for each slicer
wc =
Distinct( table[WC])
Then you would create a measure used for the conditional highlighting for that column
If(
selectedvalue( WC[WC]) = selectedvalue( table[WC], "#ff00ff" )
You would do this for each column