Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi Having problems sorting want to sort by month instead of day the file is from sharepoint can anyone help Thanks John
Solved! Go to Solution.
Hi John,
That looks a little strange! First thing to do is to go to the three little dots on the top right of the visual and select sort by, at the bottom. Ensure the chart is sorted by date.
If that doesn't work, double check your date actually is a date, because PowerBI sorts dates as a whole - it shouldn't sort by days! To do this just click on your column / measure in the fields ribbon and go to the column tools section on the top ribbon. There you can determine what the data type is, and if necessary, switch it to date.
Let me know if that helps, otherwise perhaps post some sample data.
Hi John,
That looks a little strange! First thing to do is to go to the three little dots on the top right of the visual and select sort by, at the bottom. Ensure the chart is sorted by date.
If that doesn't work, double check your date actually is a date, because PowerBI sorts dates as a whole - it shouldn't sort by days! To do this just click on your column / measure in the fields ribbon and go to the column tools section on the top ribbon. There you can determine what the data type is, and if necessary, switch it to date.
Let me know if that helps, otherwise perhaps post some sample data.
Thanks
Changed it to a date field and all sorted
Thabks for you help
@Johnl , This seems like date
suppose you have months like
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year = FORMAT([Date],"mmmm-yyyy")
create a sort column and mart this as the sort column
Month Year sort = FORMAT([Date],"yyyymm")
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!