Custom sorting in column chart

[tom2013]

Hello, 

I'm trying to make a column chart in Power BI desktop to show data in ranges:

The desired order of columns is: 

- less than 50%

- 50% - 80%

- 80% - 120%

- more than 120% (there's a typo in the figure)

However I cannot find a way to specify the order of these bars (without changing the text). 

Also there's a column without label. It would be even better if you know how to hide this column in this chart (other charts will still need these rows, so I cannot just filter the rows out from the table). 

Thanks for helping! 

[parry2k · Accepted solution]

@tom2013 you should sort by another column to set the order Sort one column by another column in Power BI Desktop - Power BI | Microsoft Docs

and put visual level filter to remove the bar with blank/emoty value.

✨ Follow us on LinkedIn

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[tom2013]

Hi @parry2k , 

Thanks for your reply! It worked after several trials. 

-----------------------------------------------------------------------------------

A note for other Power BI beginners like me:

This thread might help: https://community.powerbi.com/t5/Desktop/How-to-best-categorize-data-based-on-ranges/m-p/485367 

I wouldn't recommend using SWITCH function in DAX if you want to achieve the same goal. SWITCH can only distinguish integers by itself. There are some solutions using VAR and SWITCH together as a workaround, but that can cause circular dependencie issues later when you try to sort the categories by assigning IDs to them. Using old-fashioned nested IF statement will save you some time.