highlight selected values in a table based on slicer selection

[Anonymous]

HI

I have a table:

I have a measure that links to a slicer based on the users selection

Measure = SELECTEDVALUE('Table'[label])

I would like to be able to highlight a different row of the table based on the selection of the slicer

Any suggestions

[v-xiaotang · Accepted solution]

Hi @Anonymous 

Based on your discription, you want to highlight a differenct row when you select a value in slicer. and I've created a sample for you,

-

Steps:

Create another table for slicer, in this table you need to add a column, when you select column label in slicer, then it will change the format of the row according to the relationship between column label and HightLightAnotherRow.

Then, create the measure:

conditional format =
var _sel=SELECTEDVALUE('Table (2)'[HighlightAnotherRow])
return
IF(MIN('Table'[label])=_sel,"Yellow")

Put the measure into the Background color of Values you want,

Result:

If you want the whole row highlighted, then change the Background color of “value” also.

Result:

Best Regards,

Community Support Team _ Tang

If this post helps, please consider Accept it as the solution✔️ to help the other members find it more quickly.

[PaulDBrown]

If you want the visual to maintain rows but highlight based on the selection in the slicer, you need to create an unrelated table to use as the slicer and the use a measure using SELECTEDVALUE or TREATAS to use in the conditional formatting interface.

[selimovd]

Hey @Anonymous ,

in general you can change the color with a measure and conditional formatting:

https://docs.microsoft.com/power-bi/create-reports/desktop-conditional-table-formatting#color-based-on-a-calculation

I don't know your scenario well. But if you use SELECTEDVALUE, this means that a slicer is involved. Then the other values wouldn't show up. So I'm not sure if that makes sense.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic