https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Custom-Sort-Matrix-Custom-Sort-Order-and-Amount/m-p/4312132#M11847 <P>Hi All,</P><P>&nbsp;</P><P>I am trying to sort a matrix where I have 3 "levels" in the row hiearchy. The first 2 levels, I have custom sort order tables built but for the 3rd click down, I want this sorted by amount in descending order. I have one data element in Columns and I have a few filters. Does anyone know if what I am asking is possible? I have created measures and calculated columns but Power BI will not let you sort by either of these and based on the filters, the amounts will change.</P> Tue, 03 Dec 2024 19:38:06 GMT JAWILLIAMS 2024-12-03T19:38:06Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Custom-Sort-Matrix-Custom-Sort-Order-and-Amount/m-p/4312132#M11847 <P>Hi All,</P><P>&nbsp;</P><P>I am trying to sort a matrix where I have 3 "levels" in the row hiearchy. The first 2 levels, I have custom sort order tables built but for the 3rd click down, I want this sorted by amount in descending order. I have one data element in Columns and I have a few filters. Does anyone know if what I am asking is possible? I have created measures and calculated columns but Power BI will not let you sort by either of these and based on the filters, the amounts will change.</P> Tue, 03 Dec 2024 19:38:06 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Custom-Sort-Matrix-Custom-Sort-Order-and-Amount/m-p/4312132#M11847 JAWILLIAMS 2024-12-03T19:38:06Z