Forum Discussion

JimiH's avatar
JimiH
Frequent Visitor
9 years ago
Solved

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--...
  • Greg_Deckler's avatar
    9 years ago

    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.