Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

How to create traffic lights in MATRIX

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

 

sda.JPG

 

Thanks!

4 REPLIES 4
v-jiascu-msft
Microsoft Employee
Microsoft Employee

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,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MFelix
Super User
Super User

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


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

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
Not applicable

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors