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 ...
  • 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