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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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.
Solved! Go to 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 !!!step1
step 2
step 3
step 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
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 ?
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
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 ,
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 !!!step1
step 2
step 3
step 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
User | Count |
---|---|
98 | |
76 | |
74 | |
49 | |
26 |