Forum Discussion

manuelacardonan's avatar
manuelacardonan
Frequent Visitor
2 years ago
Solved

Formato Condicional Con Porcentajes

Hola a todos

 

tengo una medida (% Cump) que me muestra la comparacion porcentual entre las columnas [Unidades Ppto] y [Unids Prod], quisiera tener un formato que me muestre los iconos de acuerdo a el resultado de [% Cump.] asi:

 

si [% Cump.] es <0 sea un icono rojo

si [% Cump.] es >= 0 y < 10 sea un icono naranja o amarillo

si es [% Cump.] es > 10 sea un icono verde.

 

Espero me puedan ayudar ya que no he encontrado la solución, muchas gracias

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi manuelacardonan ,

    Based on my testing, please try the following methods:

    1.Create the simple table.

    2.Create the new measure to calculate the percentage.

     

    % Cump = 
VAR unida = SUMX('Table', 'Table'[Unidades Ppto])
VAR unid = SUMX('Table', 'Table'[Unids Prod])
VAR result = unid - unida
RETURN
DIVIDE(result, unida)

     

    3.Create the measure to filter the percentage.

     

    Conditional formatting = 
IF([% Cump] < 0, "red",
    IF([% Cump] >= 0 && [% Cump] < 0.1, "yellow",
        IF([% Cump] > 0.1, "green")
    )
)

     

    4.Select the cump and click the conditional formatting background.

    5.Select the Field value and conditional measure.

    6.The result is shown below.

     

    Best Regards,

    Wisdom Wu

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi manuelacardonan ,

    Based on my testing, please try the following methods:

    1.Create the simple table.

    2.Create the new measure to calculate the percentage.

     

    % Cump = 
VAR unida = SUMX('Table', 'Table'[Unidades Ppto])
VAR unid = SUMX('Table', 'Table'[Unids Prod])
VAR result = unid - unida
RETURN
DIVIDE(result, unida)

     

    3.Create the measure to filter the percentage.

     

    Conditional formatting = 
IF([% Cump] < 0, "red",
    IF([% Cump] >= 0 && [% Cump] < 0.1, "yellow",
        IF([% Cump] > 0.1, "green")
    )
)

     

    4.Select the cump and click the conditional formatting background.

    5.Select the Field value and conditional measure.

    6.The result is shown below.

     

    Best Regards,

    Wisdom Wu

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