Forum Discussion
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 item for that area has been selected. For example I have this table:
| Name | WC | GG | GC | GO |
| Eric Smith | Y | RR | N | Y |
| Jane Doe | Y | Y | N | Y |
| Adam Dunn | N/A | RR | N | Y |
| Carol Smith | N | N | Y | Y |
If I use the WC slicer and select "Y", I would the cells in that column to be highlighted like this:
| Name | WC | GG | GC | GO |
| Eric Smith | Y | RR | N | Y |
| Jane Doe | Y | Y | N | Y |
Is this possible to do?
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")
4 Replies
You already get cell highlighting as part of the standard UX. Don't reinvent the wheel.
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
