trying to use conditional formatting

[lawada]

hello everyone!

i have created a cohort in power bi in a matrix visual and im trying to change the values backgroundcolor using the conditional formating however im unable to get my intended output 

 this is the output im getting:

i want to to exculude color from first column with a title '0'  which only have '100%' value, so backgroundcolor should appear starting from column 1 and i want the color rule to apply to rows instead of columns . so for a specific month , i want to see the color changing between the values from 1 to 20 according to the values for that month .

thanks in advance

[Fowmy · Accepted solution]

@lawada 

I created a sample file with my data and tried to answer your question.  To apply CF across columns by row, you need to create a measure that ranks the values across columns and excludes the unnecessary column: Please check the measure below. File attached below

CF Rank = 
IF(
    MAX(financials[Month Number])<>1,
    CALCULATE(
        RANKX(
            ALLSELECTED( financials[Month Number] ),
            [Total Units]
        ),
        KEEPFILTERS( financials[Month Number] <> 1 )
    )
)

When you apply conditional formatting, choose Don't Format under default Formatting

[lawada]

working perceftly. thank you !