Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Helper V
4 years ago
Solved

Conditional Formatting for Each row

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

    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's avatar
amitchandak
Super User
4 years ago

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