title: Power BI - Evaluate the logic and Highlight the subtotals (Conditional Formatting)
body: <p>Is it possible to highlight the <strong>subtotals</strong> of a matrix based on conditions (Dynamic Measure).
  This Requirement is very much do-able in Excel. But, Can we do the same with Power BI.</p>
  
  <p><a href="https://i.stack.imgur.com/sMvuw.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sMvuw.jpg" alt="An Working Example on MS Excel"></a></p>
  
  <p>The Subtotal row (Total on the screenshot) has been highlighted as red if the allocation is more than the capacity and highlighted as green if the allocation is lesser than the capacity and when it is equal it is highlighted in Yellow.</p>
  
  <p>Adding the thread postponed on the Power BI Community here :- <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>
  
  <p>Kindly let me know, if this is do-able now by making changes in the Model and provide a small working example.</p>