Measures not available as conditional formatting

[Barkwi]

I use a simple switch measure to format a matrix table color based on a team index. Up until the last update to the PBI service this was still possible without any issue. It works well in the desktop app but not in the cloud service. Does the service no longer accept measures with hex values? Here is the DAX formula:

M_Gauge_Color = SWITCH(
    TRUE(),
    SUM('Team Code'[Index]) = 0, "#facfea",
    SUM('Team Code'[Index]) = 1, "#f2edd3",
    SUM('Team Code'[Index]) = 2, "#cbf5db",
    SUM('Team Code'[Index]) = 3, "#c2e1fc",
    SUM('Team Code'[Index]) = 6, "#b6f2fc")

Thanks!

[v-jialluo-msft · Accepted solution]

Hi  @Barkwi ,

After testing, your color coding is correctly recognized by the service, and you can try republishing the dataset to see if this can be fixed.

The service still supports recognizing such encodings.

Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.