Forum Discussion
Conditional formatting multiple columns in matrix separately
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
hi, VEG_Admin
You just need to drag [$/SF] measure into Values of matrix but then do conditional formatting based on [$/SF/CostCode] measure
For example:
here is my pbix file, please try it.
[$/SF/CostCode] is only used when do conditional formatting, don't drag it into Values.
Best Regards,
Lin
This isn't quite right, the colors are carrying across all the columns for each building, i.e. Building 1200 is always red, regardless of whether it is the most or least expensive per square foot. I need the red value to be the lowest amount in each column, not just the building with the lowest total. So 1200 would be red in column B because it is the lowest, but green in column A becuase it is the highest.
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
FANTASTIC!!! That worked. I really appreciate you figuring that out for me. Thank you so much for the help.
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?