Forum Discussion

lfvc1984's avatar
lfvc1984
Frequent Visitor
7 years ago

Advance card problems with conditions

Hi everyone,

 

I have a problem with some advance cards because i need to show with colors the indicators according this conditions:

 

 

Sadly for me, the advance card can only compare the values in one way, > or < or =, but in some indicators i need 2 conditions as you can see in the table.

 

I only think in a DAX formula for the compartions values to solve this issue, but i don´t know which one...

 

By the way, this is the dashboard:

 

 

Thanks for your help!

Need Help

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi lfvc1984

    Does the color condition follow as below?

    item descrpt valor color
    1 plazo 105% red
    2 produccion 63% yellow
    3 facturado 70% green
    4 gasto 49% green
    5 meta mo 64% red
    6 meta oc 93% red
    7 flujo 21% green

     

    Does the color in your dashboard for your advanced card right?

    What do you mean "in some indicators i need 2 conditions as you can see in the table"?

     

    Best Reagrds

    Maggie

     

    • lfvc1984's avatar
      lfvc1984
      Frequent Visitor
      7 years ago

      Hi Maggie,

       

      Thanks for the reply,

       

      The color condition that you describe is right.

       

      About the 2 conditions, take a look to "Plazo" indicator:

       

      For Red, it must be greater than 1

      For Yellow, it must be greater than "Facturado"

      For Green, it must be less than "Producción", and here is my problem, because advance card only let me put one comparission: Greater, Less or Equal. So the only option i can imagine is create a DAX formula to make a comparition of "Plazo" vs "Producción", and if "Plazo < Producción" generate a value or something.