Forum Discussion

Barkwi's avatar
Barkwi
Frequent Visitor
3 years ago
Solved

Measures not available as conditional formatting

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!

  

  • 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.

     

1 Reply

  • v-jialluo-msft's avatar
    v-jialluo-msft
    Icon for Community Support rankCommunity Support

    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.