Forum Discussion

VEG_Admin's avatar
VEG_Admin
Frequent Visitor
7 years ago
Solved

Conditional formatting multiple columns in matrix separately

I have a matrix with multiple columns, and I'd like the conditional formatting to apply to each column separately, instead of to the entire matrix.  The current result I have formats the background r...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, VEG_Admin 

    Sorry for my careless, you could try this formula for [$/SF/CostCode]

    $/SF/CostCode = RANKX(ALLSELECTED('Buildings'[Building Name]),[$/SF],,ASC)

    Result:

     

    By the way, in the 4th column, these three 0.01 values are different value indeed, please put four decimal places for [

    $/SF

    ].

     

     

    Best Regards,

    Lin

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, VEG_Admin 

Sorry for my careless, you could try this formula for [$/SF/CostCode]

$/SF/CostCode = RANKX(ALLSELECTED('Buildings'[Building Name]),[$/SF],,ASC)

Result:

 

By the way, in the 4th column, these three 0.01 values are different value indeed, please put four decimal places for [

$/SF

].

 

 

Best Regards,

Lin

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lili6-msft 

Thanks for the solution!

In my case - I had a "Sort by column" for the [Building Name], so the ranking didn't work somehow...

Only when I deleted the "Order" column - then the RANKX worked.

So now my "buildings" aren't ordered the way I wanted, but the ranking works.

Any ideas how to overcome this?