Traffic light in Table visual

[poojithas]

Hi All,

I have a requirement to show traffic light in a table visual. 

I am able to show one of the colors in the table using condiitonal formatting but my requirement is to show all the three circles as below and fill the circles with color based on the condition. Can someone please suggest how this can be achieved?

Thank you

[Jayee]

Hi @poojithas 

Use these 2 unichar measures and do conditional formatting

Circle1 = UNICHAR(11044)

Circle2 = UNICHAR(9675)

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[poojithas]

@Jayee 

I have created one measure for circle1=unichar(11044) and have achieved the filled circles with conditional format shown below.

Power BI report

Conditional formatting

Could you please provide the steps on how I can use conditional formatting to achive the other two unfilled circles. (eg: unfilled circled for green and unfilled circle for orange as per first the screenshot above).

[Jayee]

@poojithas ,

Cannot create exact in your image but create same measure 3 times  and use in table

and you have 3 conditions in Conditional format only apply 1 condition for 1 column so you get 3 colours for 3 columns and reduce the size of these fields and rename in table visual with space.

Example somehow  it will look like I used 2 conditions only so got two colours in one row nevermind

if you need simmilar to your exact requirement you need to create 3 measures to switch bothe unichar measures based same colour conditions you have used in measure it will look like this 

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[poojithas]

@Jayee Could you please share the pbix file you have used to achive both the above approaches you have mentioned.

It will be very helpful 

Thank you.

[Jayee · Accepted solution]

@poojithas 

here the link :
https://drive.google.com/file/d/1aFQNcuRlxip-BbblUTtuY0aNNoz6OJcP/view?usp=share_link

[poojithas]

@Jayee  This worked , thank you.