Forum Discussion

siddrow's avatar
siddrow
Icon for Helper III rankHelper III
2 years ago

Switch traffic light colour

Hi   I am trying to switch the colours based off mulitple criteria but I am stuck.   I created my traffic lights.   Traffic Lights = UNICHAR(11044)   I have created this measure to calcualt...
Need Help
Samarth_18's avatar
Samarth_18
Icon for Community Champion rankCommunity Champion
2 years ago

Hi siddrow ,

 

You can try to create this Due Date Days from Today as a column and then Traffic Lights Colour creates this as a column.

Please let me know if you have already tried this and what was the issue.

 

  • siddrow's avatar
    siddrow
    Icon for Helper III rankHelper III
    2 years ago

    Sorry, could you please add more info? It's not making sense to me. Are you saying created a custom column in Power Query for Due Date Days from Today? If so, I can't use this column in my measure either. 

    • Samarth_18's avatar
      Samarth_18
      Icon for Community Champion rankCommunity Champion
      2 years ago

      siddrow I am suggesting not to create any measure and go ahead with creating columns for both Due Date Days from Today and Traffic Lights Colour. You don't need to create it in power query you can create it directly after the data load.