Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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.
User | Count |
---|---|
77 | |
77 | |
67 | |
65 | |
47 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
65 |