Forum Discussion

Satz27's avatar
Satz27
Frequent Visitor
4 years ago
Solved

Change card color dynamically using measures

I have a case related to text coloring based on predefined conditions (<95% green, 95-99% yellow, > 100% red). currently I use the color feature in the data label, but the colors that appear do not m...
Need Help
Tips and Tricks
Tutorial Requests
Satz27's avatar
Satz27
Frequent Visitor
4 years ago

I tried but the result that appears error x

 

measures _OM_YTDSnapshotRendemen :

IF(SELECTEDVALUE('2  Operation Metrics'[Operational Metrics]) = "Productivity",
IF(SELECTEDVALUE('2  Operation Metrics'[Product]) = "Gondorukem",
IFERROR("(" &ROUND(100*([_OM_Actual]/[_OM_Target]),0)& "% Target)", "N/A"),
IFERROR("(" &ROUND(100*([_OM_Actual_Average]/[_OM_Target_Ach]),0)& "% Target)","N/A")),
IFERROR("(" &ROUND(100*([_OM_Actual_Average]/[_OM_Target_Ach]),0)& "% Target)","N/A"))

 

  • themistoklis's avatar
    themistoklis
    Community Champion
    4 years ago

    Satz27 

     

    It seems that the measure _OM_YTDSnapshotRendemen doesnt return a number but a text. Is that correct?

     

    Try to wrap this measure in a VALUE function. Like below:

    VALUE([_OM_YTDSnapshotRendemen])>100, "Red"

    • Satz27's avatar
      Satz27
      Frequent Visitor
      4 years ago

      for the number it's not text but I added punctuation text () & and Target text, I've temporarily deleted () & and Target but what comes out is not a colored number but text as I screenshot.

       

      • themistoklis's avatar
        themistoklis
        Community Champion
        4 years ago

        Satz27 

        This measure with the colours that you created must be used in conditional formatting not in the values section of the visual.

         

        So, add a card visual (if this is the visual that you use)

        Add the metric _OM_YTDSnapshotRendemen to this visual

         

        Now go to format options of the visual --> Click on Data Label --> then fx

        Format by: Field

        Select the new measure field that you created with the color formula