Conditional Formating Up/Down Status in a Table

[chadmyers]

I am utilizing a SQL Direct Query to pull my information into Power BI.  I am presenting the information required, however the customer would like to color code the results (red for down and yellow for unhealthy).  The dashboard is reporting both the down and unhealthy objects being reported in SCOM. 

1.  Is this possible?

2.  Any other creative ideas on how color code these results?

Thanks,

Chad Myers

Power BI Noob

[Vvelarde · Accepted solution]

@chadmyers

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.

[Sean]

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

Anyway we REALLY need to be able to build KPIs inside the PBI Desktop (not build first in PowerPivot and then import)

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6556753-ability-to-set-goals-and-thresholds-for-kpis