Conditional formatting on table visual based on slicer selection

[scorbin-j]

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? 

[Deku · Accepted solution]

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

[Deku · Accepted solution]

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

[scorbin-j]

Yes, that worked! Thank you

[scorbin-j · Accepted solution]

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"

    )

[lbendlin]

You already get cell highlighting as part of the standard UX. Don't reinvent the wheel.