Forum Discussion
Stoplight / Traffic Light System Dashboard
- Anonymous2 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 TeamIf 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
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