topic Re: &amp;quot;Sorting Matrix Data Based on Slicer Selection in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/amp-quot-Sorting-Matrix-Data-Based-on-Slicer-Selection/m-p/4363113#M173224 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="912262" data-lia-user-login="Madhu7624" class="lia-mention lia-mention-user">Madhu7624</a>&nbsp;Ok, so create a custom column in Power Query with this code:</P><DIV><DIV>=Text.Middle([Product], 1, 3)</DIV><DIV><img /><P>&nbsp;</P><P>then load data and make Sort Product a Whole Number type:</P><img /><P>&nbsp;</P><P>Now click on Product column and choose this new one in "Sort by column"</P><img /></DIV><DIV>&nbsp;</DIV><DIV>It will be ordered as you want.</DIV><DIV>&nbsp;</DIV><DIV>If it's ok please accept the answer as solution</DIV><DIV>&nbsp;</DIV><DIV>BBF</DIV><DIV>&nbsp;</DIV></DIV> Tue, 14 Jan 2025 10:27:07 GMT BeaBF 2025-01-14T10:27:07Z &quot;Sorting Matrix Data Based on Slicer Selection https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/amp-quot-Sorting-Matrix-Data-Based-on-Slicer-Selection/m-p/4363092#M173221 <P>Hi Everyone,<BR /><BR /></P><P>I want to sort the data in a matrix in a specific order. When I select a value in the slicer,&nbsp;</P><P>Below is the raw data image :<BR /><BR /></P><P>The matrix contains <STRONG>Product</STRONG> and <STRONG>Value [Measure]</STRONG>.<BR /><BR /></P><P><STRONG>Raw Data<BR /><BR /></STRONG></P><P><img /></P><P>&nbsp;</P><P><STRONG>Slicer :<BR /></STRONG></P><P><img /></P><P>&nbsp;</P><P>The order in which the products need to be sorted on the year value selected in the slicer.</P><P><img /></P><P>&nbsp;</P><P><BR />Raw Data:&nbsp;<BR /><BR /></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Table</TD></TR><TR><TD>Product</TD><TD>Year</TD><TD>Value</TD></TR><TR><TD>P3</TD><TD>2023</TD><TD>100</TD></TR><TR><TD>P2</TD><TD>2023</TD><TD>200</TD></TR><TR><TD>P1</TD><TD>2023</TD><TD>300</TD></TR><TR><TD>P8</TD><TD>2023</TD><TD>40</TD></TR><TR><TD>P6</TD><TD>2023</TD><TD>100</TD></TR><TR><TD>P1</TD><TD>2024</TD><TD>200</TD></TR><TR><TD>P3</TD><TD>2024</TD><TD>300</TD></TR><TR><TD>P2</TD><TD>2024</TD><TD>40</TD></TR><TR><TD>P14</TD><TD>2024</TD><TD>100</TD></TR><TR><TD>P12</TD><TD>2024</TD><TD>200</TD></TR></TBODY></TABLE><P><BR /><BR />slicer&nbsp;<BR /><BR /></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>slicer</TD></TR><TR><TD>Year</TD></TR><TR><TD>2023</TD></TR><TR><TD>2024</TD></TR></TBODY></TABLE><P><BR />Order needed&nbsp;<BR /><BR /></P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Order Required [ when I select year in Slicer ]</TD></TR><TR><TD>2023</TD><TD>2024</TD></TR><TR><TD>Order</TD><TD>order</TD></TR><TR><TD>P1</TD><TD>P1</TD></TR><TR><TD>P2</TD><TD>P2</TD></TR><TR><TD>P3</TD><TD>P3</TD></TR><TR><TD>P6</TD><TD>P12</TD></TR><TR><TD>P8</TD><TD><P>P14</P></TD></TR></TBODY></TABLE><P><BR /><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="202311" data-lia-user-login="BeaBF" class="lia-mention lia-mention-user">BeaBF</a>&nbsp;<BR /><BR /></P> Tue, 14 Jan 2025 10:13:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/amp-quot-Sorting-Matrix-Data-Based-on-Slicer-Selection/m-p/4363092#M173221 Madhu7624 2025-01-14T10:13:46Z Re: &quot;Sorting Matrix Data Based on Slicer Selection https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/amp-quot-Sorting-Matrix-Data-Based-on-Slicer-Selection/m-p/4363113#M173224 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="912262" data-lia-user-login="Madhu7624" class="lia-mention lia-mention-user">Madhu7624</a>&nbsp;Ok, so create a custom column in Power Query with this code:</P><DIV><DIV>=Text.Middle([Product], 1, 3)</DIV><DIV><img /><P>&nbsp;</P><P>then load data and make Sort Product a Whole Number type:</P><img /><P>&nbsp;</P><P>Now click on Product column and choose this new one in "Sort by column"</P><img /></DIV><DIV>&nbsp;</DIV><DIV>It will be ordered as you want.</DIV><DIV>&nbsp;</DIV><DIV>If it's ok please accept the answer as solution</DIV><DIV>&nbsp;</DIV><DIV>BBF</DIV><DIV>&nbsp;</DIV></DIV> Tue, 14 Jan 2025 10:27:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/amp-quot-Sorting-Matrix-Data-Based-on-Slicer-Selection/m-p/4363113#M173224 BeaBF 2025-01-14T10:27:07Z