Forum Discussion
On / Off Traffic Light Report
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
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
Thanks, you are a saviour. exactly what I was looking for.
