topic Sorting Months in Developer https://community.fabric.microsoft.com/t5/Developer/Sorting-Months/m-p/1798519#M29116 <P>Hello All,</P><P>&nbsp;</P><P>I created a report based on the following time period. I am comparing two time periods as below:</P><P>&nbsp;</P><P><U>April 2019 to March 2020&nbsp;&nbsp;</U></P><P>Please note: Values of Jan , Feb &amp; March is from 2020.</P><TABLE><TBODY><TR><TD><P><FONT face="arial black,avant garde" color="#FF0000">Jan</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Feb</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">March</FONT></P></TD><TD><P>Apr</P></TD><TD><P>May</P></TD><TD><P>Jun</P></TD><TD><P>Jul</P></TD><TD><P>Aug</P></TD><TD><P>Sep</P></TD><TD><P>Oct</P></TD><TD><P>Nov</P></TD><TD><P>Dec</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>April 2020 to Now</U></P><P>Please note: Values of Jan , Feb &amp; March is from 2021.&nbsp;&nbsp;</P><TABLE><TBODY><TR><TD><P><FONT face="arial black,avant garde" color="#FF0000">Jan</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Feb</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">March</FONT></P></TD><TD><P>Apr</P></TD><TD><P>May</P></TD><TD><P>Jun</P></TD><TD><P>Jul</P></TD><TD><P>Aug</P></TD><TD><P>Sep</P></TD><TD><P>Oct</P></TD><TD><P>Nov</P></TD><TD><P>Dec</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please note:</P><P>&nbsp;</P><P>Values in the month of Jan Feb &amp; March is from lastest year.&nbsp; April to Dec is from Previous year.</P><P>&nbsp;</P><P>I want to display matrix as below:</P><P>&nbsp;</P><P><U>April 2019 to March 2020</U></P><P>Please note: Values of Jan , Feb &amp; March is from 2020.</P><TABLE><TBODY><TR><TD><P>Apr</P></TD><TD><P>May</P></TD><TD><P>Jun</P></TD><TD><P>Jul</P></TD><TD><P>Aug</P></TD><TD><P>Sep</P></TD><TD><P>Oct</P></TD><TD><P>Nov</P></TD><TD><P>Dec</P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Jan</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Feb</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">March</FONT></P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>April 2020 to Now</U></P><P>Please note: Values of Jan , Feb &amp; March is from 2021.&nbsp;</P><TABLE><TBODY><TR><TD><P>Apr</P></TD><TD><P>May</P></TD><TD><P>Jun</P></TD><TD><P>Jul</P></TD><TD><P>Aug</P></TD><TD><P>Sep</P></TD><TD><P>Oct</P></TD><TD><P>Nov</P></TD><TD><P>Dec</P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Jan</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Feb</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">March</FONT></P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Your help will be apprciated.&nbsp;</P><P>&nbsp;</P><P>SD</P><P>&nbsp;</P> Wed, 21 Apr 2021 20:26:39 GMT sdhn 2021-04-21T20:26:39Z Sorting Months https://community.fabric.microsoft.com/t5/Developer/Sorting-Months/m-p/1798519#M29116 <P>Hello All,</P><P>&nbsp;</P><P>I created a report based on the following time period. I am comparing two time periods as below:</P><P>&nbsp;</P><P><U>April 2019 to March 2020&nbsp;&nbsp;</U></P><P>Please note: Values of Jan , Feb &amp; March is from 2020.</P><TABLE><TBODY><TR><TD><P><FONT face="arial black,avant garde" color="#FF0000">Jan</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Feb</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">March</FONT></P></TD><TD><P>Apr</P></TD><TD><P>May</P></TD><TD><P>Jun</P></TD><TD><P>Jul</P></TD><TD><P>Aug</P></TD><TD><P>Sep</P></TD><TD><P>Oct</P></TD><TD><P>Nov</P></TD><TD><P>Dec</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>April 2020 to Now</U></P><P>Please note: Values of Jan , Feb &amp; March is from 2021.&nbsp;&nbsp;</P><TABLE><TBODY><TR><TD><P><FONT face="arial black,avant garde" color="#FF0000">Jan</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Feb</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">March</FONT></P></TD><TD><P>Apr</P></TD><TD><P>May</P></TD><TD><P>Jun</P></TD><TD><P>Jul</P></TD><TD><P>Aug</P></TD><TD><P>Sep</P></TD><TD><P>Oct</P></TD><TD><P>Nov</P></TD><TD><P>Dec</P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please note:</P><P>&nbsp;</P><P>Values in the month of Jan Feb &amp; March is from lastest year.&nbsp; April to Dec is from Previous year.</P><P>&nbsp;</P><P>I want to display matrix as below:</P><P>&nbsp;</P><P><U>April 2019 to March 2020</U></P><P>Please note: Values of Jan , Feb &amp; March is from 2020.</P><TABLE><TBODY><TR><TD><P>Apr</P></TD><TD><P>May</P></TD><TD><P>Jun</P></TD><TD><P>Jul</P></TD><TD><P>Aug</P></TD><TD><P>Sep</P></TD><TD><P>Oct</P></TD><TD><P>Nov</P></TD><TD><P>Dec</P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Jan</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Feb</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">March</FONT></P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P><U>April 2020 to Now</U></P><P>Please note: Values of Jan , Feb &amp; March is from 2021.&nbsp;</P><TABLE><TBODY><TR><TD><P>Apr</P></TD><TD><P>May</P></TD><TD><P>Jun</P></TD><TD><P>Jul</P></TD><TD><P>Aug</P></TD><TD><P>Sep</P></TD><TD><P>Oct</P></TD><TD><P>Nov</P></TD><TD><P>Dec</P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Jan</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">Feb</FONT></P></TD><TD><P><FONT face="arial black,avant garde" color="#FF0000">March</FONT></P></TD></TR><TR><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD><TD><P>&nbsp;</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Your help will be apprciated.&nbsp;</P><P>&nbsp;</P><P>SD</P><P>&nbsp;</P> Wed, 21 Apr 2021 20:26:39 GMT https://community.fabric.microsoft.com/t5/Developer/Sorting-Months/m-p/1798519#M29116 sdhn 2021-04-21T20:26:39Z Re: Sorting Months https://community.fabric.microsoft.com/t5/Developer/Sorting-Months/m-p/1804662#M29157 <P><FONT face="tahoma,arial,helvetica,sans-serif">HI&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/136873">@sdhn</a>,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">I'd like to suggest you create a custom sorting order table and link to raw table fields and use new table fields on your chart to achieve custom sort order.</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif"><A href="http://www.excelnaccess.com/custom-sorting-in-power-bi/" target="_self">Custom Sorting in Power BI</A>&nbsp;</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Regards,</FONT></P> <P><FONT face="tahoma,arial,helvetica,sans-serif">Xiaoxin Sheng</FONT></P> Mon, 26 Apr 2021 01:39:22 GMT https://community.fabric.microsoft.com/t5/Developer/Sorting-Months/m-p/1804662#M29157 Anonymous 2021-04-26T01:39:22Z