Forum Discussion
renecornish
5 years agoRegular Visitor
Formato condicional
Oye, necesito ayuda con el formato condicional. Tengo dos medidas, una TARGET y la otra la MEDIDA real. Quiero cambiar el color de la barra a VERDE si se ha logrado la medida y RED si no. ¿Cómo ha...
renecornish
5 years agoRegular Visitor
What I ended up doing which worked well was creating 2 measures...
- Green = IF(SUM([MEASURE])<=SUM([TARGET MEASURE]),SUM(MEASURE]),0)
- RED = IF(SUM([MEASURE])>SUM([TARGET MEASURE]),SUM(MEASURE]),0)
This way I was able to do conditional formatting on these results.