https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Regarding-Sorting-of-data-having-different-format-in-same-column/m-p/3176053#M114644 <P>Hello Sap,</P><P>&nbsp;</P><P>Maybe <A href="https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi" target="_self">this article about custom sort order</A> will be of use to you. <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P><P><BR /><FONT size="2">----------------------------------</FONT><BR /><FONT size="2">If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)</FONT></P> Thu, 06 Apr 2023 13:19:07 GMT Wilson_ 2023-04-06T13:19:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Regarding-Sorting-of-data-having-different-format-in-same-column/m-p/3175877#M114632 <P>In my data there is a period column. I need my data in sorting. like 1-Month,3-Month,6_Month,1_Year in this manner. what is the solution for it.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>period</TD></TR><TR><TD>1_years</TD></TR><TR><TD>2_years</TD></TR><TR><TD>3_years</TD></TR><TR><TD>5_years</TD></TR><TR><TD>1_months</TD></TR><TR><TD>3_months</TD></TR><TR><TD>6_months</TD></TR><TR><TD>2021</TD></TR><TR><TD>2022</TD></TR><TR><TD>2019</TD></TR><TR><TD>2020</TD></TR><TR><TD>2018</TD></TR><TR><TD>2023</TD></TR></TBODY></TABLE> Thu, 06 Apr 2023 11:26:53 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Regarding-Sorting-of-data-having-different-format-in-same-column/m-p/3175877#M114632 Sap 2023-04-06T11:26:53Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Regarding-Sorting-of-data-having-different-format-in-same-column/m-p/3176053#M114644 <P>Hello Sap,</P><P>&nbsp;</P><P>Maybe <A href="https://radacad.com/sort-a-column-with-a-custom-order-in-power-bi" target="_self">this article about custom sort order</A> will be of use to you. <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P><P><BR /><FONT size="2">----------------------------------</FONT><BR /><FONT size="2">If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)</FONT></P> Thu, 06 Apr 2023 13:19:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Regarding-Sorting-of-data-having-different-format-in-same-column/m-p/3176053#M114644 Wilson_ 2023-04-06T13:19:07Z