https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Matrix-visual/m-p/3274782#M121471 <P><img /></P><P>Now my matrix visual looks like this: I placed status in the value field and the same status column in the row field. I used conditional formatting to color the background and also used green color on the blank value and 'D'.<BR /><BR />However, I would like the visual to appear like this.</P><P><img /><BR />The idea is simple. The D is the available item. D should appear after or before A, B, or C on the chart depending on the date. Some item statuses have only D, thus I can't filter them out.</P><P><A title="Dataset" href="https://docs.google.com/spreadsheets/d/1a3JonDRfHtIzAlpWG1hQnNJ68c6d2vKe/edit?usp=sharing&amp;ouid=112315269167815576605&amp;rtpof=true&amp;sd=true" target="_blank" rel="noopener">https://docs.google.com/spreadsheets/d/1a3JonDRfHtIzAlpWG1hQnNJ68c6d2vKe/edit?usp=sharing&amp;ouid=112315269167815576605&amp;rtpof=true&amp;sd=true</A>&nbsp;</P><P>&nbsp;</P><P><STRONG>It would be fantastic if anyone could assist with this report direct query method.</STRONG></P><P>&nbsp;</P> Thu, 08 Jun 2023 13:46:17 GMT aslam-ansari 2023-06-08T13:46:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Matrix-visual/m-p/3274782#M121471 <P><img /></P><P>Now my matrix visual looks like this: I placed status in the value field and the same status column in the row field. I used conditional formatting to color the background and also used green color on the blank value and 'D'.<BR /><BR />However, I would like the visual to appear like this.</P><P><img /><BR />The idea is simple. The D is the available item. D should appear after or before A, B, or C on the chart depending on the date. Some item statuses have only D, thus I can't filter them out.</P><P><A title="Dataset" href="https://docs.google.com/spreadsheets/d/1a3JonDRfHtIzAlpWG1hQnNJ68c6d2vKe/edit?usp=sharing&amp;ouid=112315269167815576605&amp;rtpof=true&amp;sd=true" target="_blank" rel="noopener">https://docs.google.com/spreadsheets/d/1a3JonDRfHtIzAlpWG1hQnNJ68c6d2vKe/edit?usp=sharing&amp;ouid=112315269167815576605&amp;rtpof=true&amp;sd=true</A>&nbsp;</P><P>&nbsp;</P><P><STRONG>It would be fantastic if anyone could assist with this report direct query method.</STRONG></P><P>&nbsp;</P> Thu, 08 Jun 2023 13:46:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Matrix-visual/m-p/3274782#M121471 aslam-ansari 2023-06-08T13:46:17Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Matrix-visual/m-p/3277351#M121607 <P>COALESCE(&lt;your value&gt;,"D")</P> Fri, 09 Jun 2023 23:06:15 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Help-with-Matrix-visual/m-p/3277351#M121607 lbendlin 2023-06-09T23:06:15Z