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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
flapponi
New Member

bar chart sort axis

Hi,

I am struggling in plotting a bar chart with continuous axis sorted according to my preference. This seems to be allowed only if I select a categorical axis data type (but in this case the outcome is not desirable), but surprisingly not for continuous axis type!?!  Is there a work around? 

 

See below

 

flapponi_0-1635414245057.png

 

flapponi_1-1635414260781.png

 

Txs,

 

Fabio

2 REPLIES 2
flapponi
New Member

In reality I will be most happy to just invert the axis (sort for descending order). This is actually possible for the x axis (there's an invert axis option) but not for the y axis. As my y axis is depth below surface I will like to have them plotted inverted and being numbers it shoul dbe in theory a very simplye thing to do....  

ibarrau
Super User
Super User

Hi. I don't think you can and it's ok if you think about it. The continious axis means that the value for the axis is a number or date that will show all the values it can inside showing an aggregation in the visual with the size of the visual. This forces the visual to show in scale order by that because it is grouping the axis to show. If you change the sort for a different thing it won't be able to do any of that. If you want to sort by value that's why you can change to categorical to show that order value by value not aggregating the quotatin on the axis.

I hope that make sense.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.