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