Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 red to green, but since one column has a large number in it that one value is red and the entirety of the rest of the matrix, not just the column with the large number, is green. Is this possible?
Solved! Go to Solution.
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 [
].
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |