Forum Discussion
Conditional Formating Up/Down Status in a Table
1. Is not possible applied conditional format to text only values.
2. A solution maybe is:
Create a calculated column with numbers according to your status:
Color = SWITCH(Tabla1[STATUS];"DOWN";1;"UNHEALTHY";2;3)
3: Next in a table:
Put Display name and Average of Color
4. With conditional format select colors to 1;2 and 3.
5. Adjust the width of colum to hide the headers.
1. Is not possible applied conditional format to text only values.
2. A solution maybe is:
Create a calculated column with numbers according to your status:
Color = SWITCH(Tabla1[STATUS];"DOWN";1;"UNHEALTHY";2;3)
3: Next in a table:
Put Display name and Average of Color
4. With conditional format select colors to 1;2 and 3.
5. Adjust the width of colum to hide the headers.
Speaking of conditional formatting
Anonymous and Vvelarde have you Voted for this Idea (it seems the PBI folks combined/consolidated 2 of the Ideas)
Hopefully that's a good sign - for implementation soon :smileyhappy:
Anyway we REALLY need to be able to build KPIs inside the PBI Desktop (not build first in PowerPivot and then import)
