title: Traffic lights in Power Bi which work also for totals
body: <p>How to make traffic light in table visual which works also for totals? Let's say our KPI is some sort of a ratio or a share like <em>GDP per capita by countries</em>, or the <em>difference from the budget by stores</em>. It is interesting to have traffic lights for individual categories but it would be even more interesting to have a traffic light for summary of all categories. </p>
  
  <p>I followed and example shown <a href="https://youtu.be/fcv3CHBItJo" rel="nofollow noreferrer">here</a>:
  The idea is based on adding a DAX measure:</p>
  
  <pre><code>TrafficLight = UNICHAR(11044)
  </code></pre>
  
  <p>And then we set up conditional formatting for traffic lights based on other column or measure. But the conditional formatting seems not to affect totals. How to have a traffic light which also shows red, yellow, green color for totals? </p>
  
  <p><a href="https://i.stack.imgur.com/wi0Yjm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wi0Yjm.png" alt="enter image description here"></a></p>
  
  <p><strong>Edit.</strong> Seems to be a dream feature you can vote for. Please do vote for it!</p>
  
  <p><a href="https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-for-total-and-subtotals-in" rel="nofollow noreferrer">https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17401381-conditional-formatting-for-total-and-subtotals-in</a></p>