Forum Discussion
Conditional Formatting one column based on another
Hi Anonymous
If you cannot do this, you need to use visual Table and then write 3 measures (separate for each category) that will return the color code.
CC Category A = IF(SELECTEDVALUE('Table (3)'[Category A]) >= SELECTEDVALUE('Table (3)'[CutOff]), "#0f0","#f00") CC Category B = IF(SELECTEDVALUE('Table (3)'[Category B]) >= SELECTEDVALUE('Table (3)'[CutOff]), "#0f0","#f00") CC Category C = IF(SELECTEDVALUE('Table (3)'[Category C]) >= SELECTEDVALUE('Table (3)'[CutOff]), "#0f0","#f00")Then for each column separately (Cat A, B, C) set the background color from conditional formatting section. Select the Field Value from the list, and then select the appropriate measure.
_______________
If I helped, please accept the solution and give kudos! 😀
Hi Anonymous
You should follow these steps.
1. Unpivot Category - put categories in one column and values in the other.
2. Create a measure that checks whether a given category value is greater than or less than CutOff. This measure will return a color code (red or green).
ConditionalColoring =
IF(SELECTEDVALUE('Table'[Value]) >= SELECTEDVALUE('Table'[CutOff]), "#0f0","#f00")
3. In the conditional formatting settings, select Field Value and then select the measure you created.
4. The Result:
I prepared the file with the solution. Please use this link to find it: https://gofile.io/d/Z3szIL
_______________
If I helped, please accept the solution and give kudos! 😀
lkalawski thanks for the quick reply.
While this does seem to get the end result I want, it changes my data structure, which is something I don't want to do. I prefer to not unpivot category as I use it for other things. So I'm guessing there's no way to do this without changing how my data is organized?
Hi Anonymous
If you cannot do this, you need to use visual Table and then write 3 measures (separate for each category) that will return the color code.
CC Category A = IF(SELECTEDVALUE('Table (3)'[Category A]) >= SELECTEDVALUE('Table (3)'[CutOff]), "#0f0","#f00") CC Category B = IF(SELECTEDVALUE('Table (3)'[Category B]) >= SELECTEDVALUE('Table (3)'[CutOff]), "#0f0","#f00") CC Category C = IF(SELECTEDVALUE('Table (3)'[Category C]) >= SELECTEDVALUE('Table (3)'[CutOff]), "#0f0","#f00")Then for each column separately (Cat A, B, C) set the background color from conditional formatting section. Select the Field Value from the list, and then select the appropriate measure.
_______________
If I helped, please accept the solution and give kudos! 😀lkalawski OK, that worked, thanks!
Although that's a ridiculous amount of work for something supposedly simple. Microsoft really need to add simple features like this.