Forum Discussion
Highlight a specific row in a table
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
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.
2 Replies
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.