Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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 ...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.