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