Highlight a specific row in a table

[Anonymous]

Hi guys,

I've the following table:

The column "Group" has categorical values. I'd like to highlight the entire row once a specific condition is met. The condition would be that the column "Group" contains a specific name. For example, Group = Pepsi --> Highlight entire row.

Any idea how I could do this?

Thanks in advance

[Anonymous]

Thank you! It works perfectly!

[Anonymous · Accepted solution]

Hi @Anonymous ,

You can create a measure and use the new 'Conditional Formating' option where you select formatting by

'Field Value' and in this you choose the measure shown below.

Create a measure.

measure=
IF  (HASONEVALUE(table[group])
    ,IF( FIRSTNONBLANK('table'[group] , 0) = "Pepsi"
        ,"lightgreen"
        ,"white"
    )
    ,BLANK()
)

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information.

Best Regards

Community Support Team _ Polly

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