Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@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 !!!
Please do give kudos to keep me motivated !!
and do accept as solution if it solved your concern
happy to help
regards
Sujit
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
@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 !!!
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 |
---|---|
96 | |
87 | |
78 | |
72 | |
69 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |