How to create traffic lights in MATRIX

[Anonymous]

Hi there,

Has anyone had any success creating a RAG or traffic light column in a MATRIX? 

i end up with black circles even if I use HASONEVALUE() to choose BLANK() rather than UNICODE(11044)...

Thanks!

[v-jiascu-msft]

Hi @Anonymous,

Please also refer to https://www.youtube.com/watch?v=fcv3CHBItJo, which presents almost the same scenario.

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Best Regards,

[MFelix]

Hi @Anonymous,

You can use this post from @Greg_Deckler with a good explanation on how to create different multi shape multi coloured symbols, and used it to create the traffic light.

Regards,

MFelix

[Anonymous]

Hi

i came across this trick one day and put it in my "it could be usefull" box :

https://www.youtube.com/watch?v=3_bLEIAhaDw

Stephane

[Anonymous]

And vote for the idea : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9378456-when-will-the-kpi-red-yel...