Forum Discussion
Formato Condicional Con Porcentajes
- Anonymous2 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.
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.
- manuelacardonan2 years agoFrequent Visitor
thank you, the answer that's correct 🙂 I found the solution