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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Ramees_123
Helper IV
Helper IV

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

@Ramees_123 ,
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 @Ramees_123 ,
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 ?

Yes, Its a calculated column.

@Ramees_123 , 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

Dear @Ramees_123  ,
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

chart.PNGtable.PNG

@Ramees_123 , refer page 2. File after signature

 

@Ramees_123 ,
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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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