Conditional formatting for each row in Power BI matrix

Question

I have a matrix visual :Row: ProductColumns: MonthYearValues: UnitCost&nbsp;For P1 If&nbsp; UnitCost 0-10 -&gt;&nbsp; Red , 10-40-&gt; Yellow, 40+GreenFor P2 If&nbsp; UnitCost 0-20 -&gt;&nbsp; Red , 20-30-&gt; Yellow, 30+GreenFor P3 If&nbsp; UnitCost 0-10 -&gt;&nbsp; Red , 10-50-&gt; Yellow, 50+GreenFor P4 If&nbsp; UnitCost 0-20 -&gt;&nbsp; Red , 10-40-&gt; Yellow, 40+GreenWhen I am trying to do this conditional formatting for P1, I am getting all the P1, P2, P3, and P4 with the same color coding.Can we get color coding for each row as per the above problem statement?&nbsp;

mahyartf · Answer

Hi,Add the column to your table with below script :Color = &nbsp; &nbsp; &nbsp; &nbsp; if ( Sheet70[ProductName] = "P1" &amp;&amp; Sheet70[UnitCost] &gt;= 0 &amp;&amp; Sheet70[UnitCost] &lt; 10, "Red",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ( Sheet70[ProductName] = "P1" &amp;&amp; Sheet70[UnitCost] &gt;= 10 &amp;&amp; Sheet70[UnitCost] &lt; 40, "Yellow",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ( Sheet70[ProductName] = "P2" &amp;&amp; Sheet70[UnitCost] &gt;= 0 &amp;&amp; Sheet70[UnitCost] &lt; 20, "Red",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ( Sheet70[ProductName] = "P2" &amp;&amp; Sheet70[UnitCost] &gt;= 20 &amp;&amp; Sheet70[UnitCost] &lt; 30, "Yellow",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ( Sheet70[ProductName] = "P3" &amp;&amp; Sheet70[UnitCost] &gt;= 0 &amp;&amp; Sheet70[UnitCost] &lt; 10, "Red",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ( Sheet70[ProductName] = "P3" &amp;&amp; Sheet70[UnitCost] &gt;= 10 &amp;&amp; Sheet70[UnitCost] &lt; 50, "Yellow",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ( Sheet70[ProductName] = "P4" &amp;&amp; Sheet70[UnitCost] &gt;= 0 &amp;&amp; Sheet70[UnitCost] &lt; 20, "Red",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if ( Sheet70[ProductName] = "P4" &amp;&amp; Sheet70[UnitCost] &gt;= 20 &amp;&amp; Sheet70[UnitCost] &lt; 40, "Yellow", "Green")&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )Then use it in your Conditional formatting :&nbsp;&nbsp;&nbsp;

amikm · Answer

Thanks,&nbsp;MahyarTF,&nbsp;I have replicated the DAX in my Power BI report, but in conditional formatting, the calculated column that I have created is grayed and I am not able to use it.I have created the calculated column in the tabular model itself as my report is connected live with the tabular model ( cube). Also, UnitCost is measure in my case that is showing data for Unitsold in 7 days

mahyartf · Answer

Hi,Have you tried my solution?Thanks for Kudos

amikm · Answer

Hi&nbsp;MahyarTF, but in my case, the calculated column that I created grayed out when I was trying to use it for conditional formatting. Also, the first color those kinds of options were not coming in my case.

Forum Discussion

Conditional formatting for each row in Power BI matrix

4 Replies

Related content

Matrix Row Conditional Formatting

Conditional Formatting using DAX

Conditional Formatting with Matrix Table

Conditional Formatting

Conditional Formatting