Forum Discussion
Traffic light in Table visual
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
6 Replies
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).
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 nevermindif 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!!
