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!View all the Fabric Data Days sessions on demand. View schedule
Hi,
I have this design in my dashboard:
And I created a bar chart using "MonthText" as x axis label, the Y label and the value are both from the table data:
* The only two sorting options I have are these
I want the month names to be sorted by the month number ( Jan=1, Feb=2,...). I've seen other posts that told you to go to table design and sort by month number (in my table, the field "Month"):
I already did that but the chart still shows the months sorted alphabetically.
Any idea what else should I try?
Thanks!
Solved! Go to Solution.
Hey @fleetingImage ,
I assume that you "followed" this article: Sort by column in Power BI Desktop - Power BI | Microsoft Docs
Please report the version of Power BI Desktop.
You may consider to upload the pbix to onedrive or dropbox and share the link.
Regards,
Tom
I tried to recreate your scenario and I do get the desired output as shown below.
I sorted the MonthName column by MonthNumber.
Can you in any way share a pbix file with this chart and data, so that I can see in detail why it's not working.
Hi Veen,
Could you attached your dummy pbix to see how mine is different?. I cannot upload one....
@fleetingImage , You should make the month as sort column of month text
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Hey @fleetingImage ,
I assume that you "followed" this article: Sort by column in Power BI Desktop - Power BI | Microsoft Docs
Please report the version of Power BI Desktop.
You may consider to upload the pbix to onedrive or dropbox and share the link.
Regards,
Tom
Hey Tom,
I actually haven't read the article, it actually holds the answer for me, sorry but I'm completelly newby to PBI
Thanks!
Perfect!
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!