Forum Discussion

m259161's avatar
m259161
New Member
8 years ago
Solved

How to create traffic lights in table

Hi Everyone   I am trying to create a traffic light system within a table, based on conditions. Currently, I have it set up with conditional formatting and the background colour and text colour ...
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi m259161

    When following SteveCampbell's suggestion, i can create Traffic light in a table visual, then edit with conditional formatting, i can change the light color conditionally.

    Additionally, you could create symbols like Traffic Signal in Power Pivot or SQL Server Analysis Service.  When you import the data to the Power BI Desktop, it may look like a Traffic Signal indicator.

    Please follow this article, if you have any question to implement in your scenario, feel free to let me know.

     

     

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Community Support
8 years ago

Hi m259161

When following SteveCampbell's suggestion, i can create Traffic light in a table visual, then edit with conditional formatting, i can change the light color conditionally.

Additionally, you could create symbols like Traffic Signal in Power Pivot or SQL Server Analysis Service.  When you import the data to the Power BI Desktop, it may look like a Traffic Signal indicator.

Please follow this article, if you have any question to implement in your scenario, feel free to let me know.

 

 

 

Best Regards

Maggie

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi All

     

    Nice post. I can learn a lot in this post.

     

    paul