Conditional Formatting for Each row

[RanjanThammaiah]

Hi All,

Just wanted to check if it's possible to have conditional formatting for each row to show the highest in green and lowest in Green or using Diverging.

Currently its applying to all the values of the table.

[Fowmy · Accepted solution]

@RanjanThammaiah 

You can create measure to rank the values across rows and apply it in your conditional formatting. Please check the attached file.

CF Rank = 

RANKX(
    ALLSELECTED(financials[Month Number]),
    CALCULATE( SUM(financials[Units Sold] ))
)

[amitchandak]

@RanjanThammaiah , Row conditional formatting is not available, you need to do conditional formatting on each value in the matrix and field in Table for row