Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to 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
Made this measure that seems to work better with multiple items selected in a slicer/slicers.
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
Yes, that worked! Thank you
Made this measure that seems to work better with multiple items selected in a slicer/slicers.
You already get cell highlighting as part of the standard UX. Don't reinvent the wheel.
User | Count |
---|---|
72 | |
66 | |
34 | |
25 | |
22 |
User | Count |
---|---|
96 | |
95 | |
56 | |
45 | |
42 |