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 

I couldn't download the sample pbix file, please re-upload.

 

Best Regards,

Lin