Forum Discussion
On / Off Traffic Light Report
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
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.
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
4 Replies
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.
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
Thank you ,worked perfectly
