Forum Discussion

Brian415_'s avatar
Brian415_
Frequent Visitor
2 years ago
Solved

Stoplight / Traffic Light System Dashboard

I have a dataset in Power BI. This dataset has 2 columns: Student Name, Status Transition Next Year. The first column is the name of the students and the second column is used to track the status ...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Brian415_ ,

    Is the traffic light a custom visual? It requires the purchase of a license, which I was unable to test further.
    Please try this measure:

     

    Measure = 
SWITCH(
    TRUE(),
    ISBLANK(SELECTEDVALUE('Table'[Status Transition Next Year])),"Red",
    SELECTEDVALUE('Table'[Status Transition Next Year])="Passed","Green",
    SELECTEDVALUE('Table'[Status Transition Next Year])="Failed","Red",
    SELECTEDVALUE('Table'[Status Transition Next Year]) IN {"Pending, Busy With Discussions","Pending, Waiting for last exam"},"Orange"
    )

     

    Or you mean this?

     

    Please try this:


    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum