https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-formatting-matrix-for-Multiple-Columns-based-on-week/m-p/4032915#M10125 <P>Hi!</P><P>Hopefully someone can help. I am struggling to recreate something that was previously done in excel into a Matrix visual in one of my reports.&nbsp;<BR /><BR />Basically, I am trying to display gradient colors using conditional formatting based on the values for multiple columns. In excel, we used conditional formatting for each individual column multiple times.&nbsp;</P><P>&nbsp;</P><P>When I attempt to use conditional formatting in Power Bi, the entire dataset is used in the gradient rather than each individual column. I have also tried creating a color table using dax and then use a gradient color measure within field value but the colors are all over the place.&nbsp;</P><P>&nbsp;</P><P>Does anyone have any suggestions?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Results I am looking for in PBIX.JPG" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1129238iEF157901119FDC45/image-size/large?v=v2&amp;px=999" role="button" title="Results I am looking for in PBIX.JPG" alt="Results I am looking for in PBIX.JPG" /></span></P> Tue, 09 Jul 2024 15:57:46 GMT Jefferbur_ 2024-07-09T15:57:46Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-formatting-matrix-for-Multiple-Columns-based-on-week/m-p/4032915#M10125 <P>Hi!</P><P>Hopefully someone can help. I am struggling to recreate something that was previously done in excel into a Matrix visual in one of my reports.&nbsp;<BR /><BR />Basically, I am trying to display gradient colors using conditional formatting based on the values for multiple columns. In excel, we used conditional formatting for each individual column multiple times.&nbsp;</P><P>&nbsp;</P><P>When I attempt to use conditional formatting in Power Bi, the entire dataset is used in the gradient rather than each individual column. I have also tried creating a color table using dax and then use a gradient color measure within field value but the colors are all over the place.&nbsp;</P><P>&nbsp;</P><P>Does anyone have any suggestions?</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Results I am looking for in PBIX.JPG" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1129238iEF157901119FDC45/image-size/large?v=v2&amp;px=999" role="button" title="Results I am looking for in PBIX.JPG" alt="Results I am looking for in PBIX.JPG" /></span></P> Tue, 09 Jul 2024 15:57:46 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-formatting-matrix-for-Multiple-Columns-based-on-week/m-p/4032915#M10125 Jefferbur_ 2024-07-09T15:57:46Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-formatting-matrix-for-Multiple-Columns-based-on-week/m-p/4087935#M10291 <P>That is a standard pattern where you use a measure for the color.&nbsp; In the measure you can remove the row filter so that it works for the entire column.</P> Thu, 08 Aug 2024 00:53:04 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Conditional-formatting-matrix-for-Multiple-Columns-based-on-week/m-p/4087935#M10291 lbendlin 2024-08-08T00:53:04Z