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