Print

Sort Y-axis in Power BI visuals

Did you know it is not possible to sort the Y-axis on Power BI visuals? But, there is a hack that will allow you to do that.

If you prefer to watch a video instead, click here:

Sort Y-axis on Power BI visuals

In a previous video, I showed you how to create a bump /rank chart using Power BI, but one of the issues we had was the inability to sort the Y-axis.

1. Convert to negative numbers

The trick I showed you on that video was to to convert the Y-axis to negative numbers, by multiplying the rank (y-axis) by -1.

Convert the Y-axis to negative number to sort y-axis Power BI

That did the trick, but we ended up hiding in the axis, as it was showing negative numbers.

2. Format the number back to a positive number

Thanks to the new formatting options, there is a possibility to turn those negative numbers to positive:

1 Go to the modeling pane
2 Find the column that defines the Y-axis
3 On the formatting section change it to Custom
4 and change $#,##0;($#,##0) to ,##0;#,##0

Change formatting to turn negative numbers to positive on Power BI

And that is all!!

3. Additional resources

If you want to have more flexibility around how your bump chart looks like, I recommend you to use charticulator to create them.

Was this helpful?

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *

Table of Contents