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 table where each row has a status. The status can be one of five: 1-Submitted, 2-Approved, 3-Rejected, 4-Scheduled, 5-Created. I would like to conditionally color the background row color based on the value of the Status column. So have a blue for Submitted, Green for Approved, Red for Rejected, Yellow for Scheduled, Black for Created.
When I got into Conditional Formatting for the table, it only lets me use 'Count' of a value. What am I missing here or is this not possible? Thanks
Solved! Go to Solution.
You will want a numeric measure like this:
Measure 5 = VAR __value = MAX(Table11[Column2]) RETURN SWITCH(TRUE(),__value = "Submitted",1,__value = "Approved",2,__value = "Rejected",3,__value = "Scheduled",4,__value = "Created",5)
go to your table.
right click for conditinal formatting.
format by rule.
select here you new measure wich only get numbers as result.
and then make the good rules wich numer gets wich color. maybe play a little bit with this combination
You will want a numeric measure like this:
Measure 5 = VAR __value = MAX(Table11[Column2]) RETURN SWITCH(TRUE(),__value = "Submitted",1,__value = "Approved",2,__value = "Rejected",3,__value = "Scheduled",4,__value = "Created",5)
Got it! I had to change to Rules. Thanks
Then in conditional formatting how would I apply the value of the ___value variable?
go to your table.
right click for conditinal formatting.
format by rule.
select here you new measure wich only get numbers as result.
and then make the good rules wich numer gets wich color. maybe play a little bit with this combination
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 |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |