Forum Discussion
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.
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 !!!
step1step 2step 3step 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
7 Replies
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 , 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
