https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Organize-data-on-column-chart-from-the-oldest-data-to-the-newest/m-p/1647421#M3567 <P>Hi everyone, I have a column chart and I want to organize my data from the oldest data to the newest. In this case, for an unknown reason the data is organized like this: 2020, Dec / 2020, Nov /2021, Feb / 2021 , Jan<BR />Is shown like this:&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="brincos22_0-1612513066303.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/448773iF4804015EE58467E/image-size/medium?v=v2&amp;px=400" role="button" title="brincos22_0-1612513066303.png" alt="brincos22_0-1612513066303.png" /></span></P><P>FYI: Ive created this column&nbsp;</P><DIV><DIV><SPAN>YearMonth = FORMAT([Created],"YYYY,MMM")</SPAN></DIV></DIV> Fri, 05 Feb 2021 08:19:20 GMT Anonymous 2021-02-05T08:19:20Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Organize-data-on-column-chart-from-the-oldest-data-to-the-newest/m-p/1647421#M3567 <P>Hi everyone, I have a column chart and I want to organize my data from the oldest data to the newest. In this case, for an unknown reason the data is organized like this: 2020, Dec / 2020, Nov /2021, Feb / 2021 , Jan<BR />Is shown like this:&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="brincos22_0-1612513066303.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/448773iF4804015EE58467E/image-size/medium?v=v2&amp;px=400" role="button" title="brincos22_0-1612513066303.png" alt="brincos22_0-1612513066303.png" /></span></P><P>FYI: Ive created this column&nbsp;</P><DIV><DIV><SPAN>YearMonth = FORMAT([Created],"YYYY,MMM")</SPAN></DIV></DIV> Fri, 05 Feb 2021 08:19:20 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Organize-data-on-column-chart-from-the-oldest-data-to-the-newest/m-p/1647421#M3567 Anonymous 2021-02-05T08:19:20Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Organize-data-on-column-chart-from-the-oldest-data-to-the-newest/m-p/1649118#M3568 <P>You need to change your YearMonth definition to&nbsp;</P> <P><SPAN>YearMonth = FORMAT([Created],"YYYYMM")</SPAN></P> <P><SPAN>or introduce a "Sort By"&nbsp; column that sorts by month number, not by month name.</SPAN></P> Sat, 06 Feb 2021 00:29:53 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Organize-data-on-column-chart-from-the-oldest-data-to-the-newest/m-p/1649118#M3568 lbendlin 2021-02-06T00:29:53Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Organize-data-on-column-chart-from-the-oldest-data-to-the-newest/m-p/1652501#M3570 <P>Thank you so much and sorry for this silly question!&nbsp;<span class="lia-unicode-emoji" title=":grimacing_face:">😬</span></P> Mon, 08 Feb 2021 16:56:14 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Organize-data-on-column-chart-from-the-oldest-data-to-the-newest/m-p/1652501#M3570 Anonymous 2021-02-08T16:56:14Z