https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-by-ASC-when-value-is-present/m-p/3154697#M113114 <P>Hello,</P><P>I'm trying to sort a column, by another column when it's present. The picture shows Categories, in bold, Names as unbolded text, and beneath the names not visible in the picture is a GL number for each name. This GL number is only present in names under the category SG&amp;A.&nbsp; I'm trying to sort these values by ascending them in my matrix. Any ideas?&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P> Sun, 26 Mar 2023 22:33:54 GMT olivere91 2023-03-26T22:33:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-by-ASC-when-value-is-present/m-p/3154697#M113114 <P>Hello,</P><P>I'm trying to sort a column, by another column when it's present. The picture shows Categories, in bold, Names as unbolded text, and beneath the names not visible in the picture is a GL number for each name. This GL number is only present in names under the category SG&amp;A.&nbsp; I'm trying to sort these values by ascending them in my matrix. Any ideas?&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P><img /></P> Sun, 26 Mar 2023 22:33:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-by-ASC-when-value-is-present/m-p/3154697#M113114 olivere91 2023-03-26T22:33:54Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-by-ASC-when-value-is-present/m-p/3155069#M113141 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="280611" data-lia-user-login="olivere91" class="lia-mention lia-mention-user">olivere91</a> , if you sort category column ascending then only below level will sort ascending . As of now, multiple sort is not available in Matrix visual </P> Mon, 27 Mar 2023 03:58:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sort-by-ASC-when-value-is-present/m-p/3155069#M113141 amitchandak 2023-03-27T03:58:07Z