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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

Clustered Column Chart X Axis sorting

In Clustered Column Chart I am displaying the employee count by age interval like  40-50, 30-40, Now its displaying the decreasing order of the employee count, i want to make the visual like increasing order of the x axis value 30-40,40-50,50-60,How can i achieve this.

1 ACCEPTED SOLUTION

@Anonymous ,
Thanks for prompt response !!
Here is your solution

Firstly select your visual 
secondly click on three dots which will apper after you select your visual .

 

Then 
click on it , 
a drop down will apper which has a option in last labelled as "sort by"
Select your calculated column in that option 
then just above "sort by " select "Sort ascending "

Then done !!!

step1step1step 2step 2step 3step 3step 4 :select sort ascendingstep 4 :select sort ascending

Please do give kudos to keep me motivated !!
and do accept as solution if it solved your concern
happy to help

regards 
Sujit

View solution in original post

7 REPLIES 7
Sujit_Thakur
Solution Sage
Solution Sage

Dear @Anonymous ,
Can you let me know that is 30-40 , 40-50 are seperate fields?? i mean to say these are different columns in your model ?

Anonymous
Not applicable

Yes, Its a calculated column.

@Anonymous , Looking at data you should be able use sort option from three dots

 

if not Create sort order for this column using the switch and the mark that as sort column.

 

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

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

Dear @Anonymous  ,
it implies that it is something like this ??

Column
30-40
40-50
30-40
50-60
10-20
50-60


Please provide a screenshot of your visual and also of visual pane so that i can examine and tell you exactly what to do to get to your solution

regards ,
Sujit

Anonymous
Not applicable

chart.PNGtable.PNG

@Anonymous , refer page 2. File after signature

 

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

@Anonymous ,
Thanks for prompt response !!
Here is your solution

Firstly select your visual 
secondly click on three dots which will apper after you select your visual .

 

Then 
click on it , 
a drop down will apper which has a option in last labelled as "sort by"
Select your calculated column in that option 
then just above "sort by " select "Sort ascending "

Then done !!!

step1step1step 2step 2step 3step 3step 4 :select sort ascendingstep 4 :select sort ascending

Please do give kudos to keep me motivated !!
and do accept as solution if it solved your concern
happy to help

regards 
Sujit

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Kudoed Authors