Conditional Formatting for Each row

Question

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.&nbsp;&nbsp;&nbsp;&nbsp;

fowmy · Accepted Answer

RanjanThammaiah&nbsp;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] ))
)

&nbsp;

Forum Discussion

Conditional Formatting for Each row

2 Replies

Related content

Conditional Formatting using DAX

Conditional Formatting

Conditional Formatting

Matrix Row Conditional Formatting

Condition formatting