Forum Discussion
jac88
4 years agoHelper II
Why conditional formatting not working?
Hello, I have a calendar that conditional format background color based on Duration_Hr, but some of them are not working correctly. Just one example, on May 16 Brian Buss should be the Brown co...
v-yanjiang-msft
4 years agoCommunity Support
Hi jac88 ,
According to your description, I download your sample. I create a seperate measure to show the BillableColors in your color measure.
Then put the measure in the matrix, you can see, for the May 16, the BillableColors of Brian Buss is 35(32+3), not 3. Because the Admin and Billable categories are all in the same cell.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.