Another conditional formatting issue

[ghoulars]

So I have a bunch of calculated columns that each score one project health indicator (0 for not complete, 1 for complete or voided). Then, I have another calculated column for overall project health. If the sum is 0 - 10, the project is in red, 11 - 15 yellow and 16 is green (all tasks done). 

I have all this in a table using conditional formatting rules to color each task (0 is yellow, 1 is green), and red, yellow, green icons on the project depending on the overall project health. 

My issue is that the conditional statement only works sometimes, even though all the numbers are correct. It even seems to "randomly" change after a refresh.

Here is the calculated columns. As far as I can see, all numbers are correctly generated (I've used isnumber to verify formatting)

Here is the conditional formatting for the different indikators

And here is how it looks:

An idea what could be wrong?

[v-yiruan-msft]

Hi @ghoulars ,

Thanks for reaching out to us with your problem. Base on your description, it seems that you are configuring the conditional formatting for the columns with different levels(all project, per project and per task). However, it doesn't work correctly. Could you please provide some raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following link to share the required info:

How to provide sample data in the Power BI Forum

And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards

[ghoulars]

Tried to do this as simple as possible. Just set every project to 16, the make one color if the sum = 16. Three of 80 projects was correctly colored.