Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a clustered column chart that I would like to have sorted based on ascending or descending order of the Y axis. I have the total downtime as my Y axis, and the dt category as my legend. Currently it is sorting the columns based on the alphabetical order of the downtime category instead of the total minutes of downtime for each.
Solved! Go to Solution.
Hi @Anonymous ,
Can you add some sreenshots around the issue you are seeing?
I don't see this happening at my end.
I created a clustered column chart as shown below:
Now if I want to sort based on gross-income (my y-axis), I get an option to do it:
Once sorted I get the chart as follows:
This is descending order by default. This can be changed to ascending as well:
The result is:
Let me know if you see a different behaviour. Add more details.
Hi @Pragati11,
This worked thank you for the help! I just had to move my descriptor column to the x axis rather than the legend section. I am very new to the application and appreciate you taking the time!
Hi @Anonymous ,
Can you add some sreenshots around the issue you are seeing?
I don't see this happening at my end.
I created a clustered column chart as shown below:
Now if I want to sort based on gross-income (my y-axis), I get an option to do it:
Once sorted I get the chart as follows:
This is descending order by default. This can be changed to ascending as well:
The result is:
Let me know if you see a different behaviour. Add more details.
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
25 | |
13 | |
11 | |
9 | |
6 |