On / Off Traffic Light Report

[JimiH]

I have a very simple table like below

Line-----Running

1--------Yes

2--------Yes

3--------No

4--------No

5--------No

6--------Yes

7--------Yes

8--------No

9--------Yes

10-------No

11-------No

12-------No

What I want is to display this with traffic lights ,is this possible with power BI?

Regards

Geoff

[Greg_Deckler · Accepted solution]

Sort of. Here is one idea. First, create a calculated column like so:

RunningBoolean = IF([Running]="Yes",1,0)

Next, create a measure like so:

Measure = FIRSTNONBLANK(VALUES(Table[RunningBoolean]),"")

No, put your Line and your Measure into a table. You should now be able to click on the measure in your fields area and choose Conditional Formatting.

Conditional Formatting in tables only works with numeric measures.

[Greg_Deckler · Accepted solution]

Sort of. Here is one idea. First, create a calculated column like so:

RunningBoolean = IF([Running]="Yes",1,0)

Next, create a measure like so:

Measure = FIRSTNONBLANK(VALUES(Table[RunningBoolean]),"")

No, put your Line and your Measure into a table. You should now be able to click on the measure in your fields area and choose Conditional Formatting.

Conditional Formatting in tables only works with numeric measures.

[parry2k · Accepted solution]

here is the link to a solution pbix file. show images, you need to host image on your public site and change the parameter value

https://drive.google.com/file/d/0B8z5lc1oML-hdkpvREdMbDV5aUE/view?usp=sharing

[chowdarygm]

Thanks, you are a saviour. exactly what I was looking for.

[JimiH]

Thank you ,worked perfectly