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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
inservo
Helper I
Helper I

Clustered Column Chart - I can't sort

Hi there,

this drives me crazy. I can't sort my clustered column chart by years. It goes from highest to lowest and I don't know why. 

 

Here is my chart:

inservo_0-1680673401254.png

 and this is how my fields are set up

inservo_1-1680673432739.png

From all posts, videos etc it seems there should be the option to sort by the Fiscal Year and then descending but somehow I can't.

Even if I delete the the legend or the X-axis, I cannot sort it.

 

Any ideas?

2 REPLIES 2
amitchandak
Super User
Super User

@inservo , there is one more option, the Sort axis, Missing in your case.

 

Make sure, no Windows update is pending. Reinstall the latest version of Power bi again

 

amitchandak_0-1680676593915.png

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

I don't have the option of the sort axis.

 

And with all due respect, NO, I will definitely not follow any "reinstall" advice. This might be working for stuff like Minecraft and the likes, but we are speaking about a professional BI solution. Uninstalling and reinstalling is not an option for professionals.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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