Forum Discussion

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
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

VEG_Admin

Frequent Visitor

7 years ago

Lin,

Thank you for the reply. That didn't do it, I'm thinking its becuase I've oversimplified my model. There are actually three tables involved, one with the Buildings, one with the chart of accounts, and one with the transactions (GL). When I tried your method below I get the same result now for every cost code across each building (i.e. it is calculating the total $/sf instead of the $/sf/cost code). I recreated the model on my personal machine so that I can share it out. The link is below. I've left several visuals on there showing the different methods I tried.

https://salsallc-my.sharepoint.com/:u:/g/personal/andy_valleyequitygroup_com/Ec_wpTghJm1Im4S_nM4cmfYBx8-SwHlczKMdcfmfS8aaQQ?e=orVMBy

Thanks again for all the help.

Andy

v-lili6-msft

Community Support

7 years ago

hi, VEG_Admin

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