Forum Discussion

lawada's avatar
lawada
Helper III
4 years ago
Solved

trying to use conditional formatting

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

 

Need Help
Tips and Tricks
  • Fowmy's avatar
    Fowmy
    4 years ago

    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

     

     



     

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    4 years ago

    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