Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Sorting/filter data by particular month in line chart

Hello all, 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.



Super User
Super User

Use a Ribbon Chart.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.