https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-filter-data-by-particular-month-in-line-chart/m-p/3171695#M114334 <P>Hello all,&nbsp;<SPAN>I have a query about sorting data in a particular month in line chart. Line chart is showing a series of data, example as below. At the moment, my top 5 item groups are sorted by total value of item groups. What if at each month, I need to sort the data in descending order for that particular month, how do I do it in filter or DAX? It’s easy in excel by just sorting a particular column, but I don’t know how to do it in Power BI. As I’m sorting item group orders at each month, which means my top 5 item groups will be different as at each month.</SPAN></P><P><img /></P><P>&nbsp;</P> Tue, 04 Apr 2023 12:21:18 GMT Carol_W 2023-04-04T12:21:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-filter-data-by-particular-month-in-line-chart/m-p/3171695#M114334 <P>Hello all,&nbsp;<SPAN>I have a query about sorting data in a particular month in line chart. Line chart is showing a series of data, example as below. At the moment, my top 5 item groups are sorted by total value of item groups. What if at each month, I need to sort the data in descending order for that particular month, how do I do it in filter or DAX? It’s easy in excel by just sorting a particular column, but I don’t know how to do it in Power BI. As I’m sorting item group orders at each month, which means my top 5 item groups will be different as at each month.</SPAN></P><P><img /></P><P>&nbsp;</P> Tue, 04 Apr 2023 12:21:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-filter-data-by-particular-month-in-line-chart/m-p/3171695#M114334 Carol_W 2023-04-04T12:21:18Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-filter-data-by-particular-month-in-line-chart/m-p/3179053#M114891 <P>Use a Ribbon Chart.</P> Sun, 09 Apr 2023 23:45:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Sorting-filter-data-by-particular-month-in-line-chart/m-p/3179053#M114891 lbendlin 2023-04-09T23:45:43Z