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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.