Forum Discussion

jac88's avatar
jac88
Helper II
4 years ago

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 color background, but it showing Green, could not figure out why is that, I already filtering the category to "b_billable". 

 

Can anybody please let me know what I am doing wrong here? 

 

Duration_Color = 
VAR TotalDuration = SUM(df_ProServUtilizationTracker[Duration_Hr])
VAR BillableColors = CALCULATE(SUM(df_ProServUtilizationTracker[Duration_Hr]), FILTER(df_ProServUtilizationTracker, MIN(df_ProServUtilizationTracker[Primary Categories Order]) = "b_billable"))

RETURN (
    IF(TotalDuration > 8 && 
        MIN(df_ProServUtilizationTracker[Primary Categories Order]) <> "c_pto" && 
        MIN(df_ProServUtilizationTracker[Primary Categories]) <> "OoO" && 
        MIN(df_ProServUtilizationTracker[Primary Categories]) <> "Admin" && 
        MIN(df_ProServUtilizationTracker[Primary Categories]) <> "Unavailable", "#FF7F7F",
    IF(MIN(df_ProServUtilizationTracker[Primary Categories Order]) = "a_hold", "#fdee00", 
    IF(MIN(df_ProServUtilizationTracker[Primary Categories Order]) = "b_billable" && BillableColors >=  8, "#92D050" ,
    IF(MIN(df_ProServUtilizationTracker[Primary Categories Order]) = "b_billable" && BillableColors >=  0, "#C65911" ,
    IF(MIN(df_ProServUtilizationTracker[Primary Categories Order]) = "c_pto", "#1E90FF", 
    IF(MIN(df_ProServUtilizationTracker[Primary Categories Order]) = "f_admin", "#EE82EE", 
    IF([Titles] = "Weekend", "#dde2de",
    IF([Titles] = "iMetaWeekend", "#dde2de"
   
)))))))))

 

https://drive.google.com/file/d/1yKEQ60MPq_5wQfzllzGNtFz_iqCZjoz4/view?usp=sharing

 

Thank you so much 

Need Help
Show and Tell
Tips and Tricks

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    4 years ago

    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.