Custom sort of clustered bar chart attributes

[steambucky]

This is my clusted bar chart - I want to change the order of the bars. Not alphabectically. My own specific order. 

This is my data. 

AttributeValue

Data release process	4
Standards development & adoption	3
Data governance	5
Managing sensitive data	5
Open data expertise	1
Knowledge management	5
Engagement process	2
Open data documentation	5
Re-user support processes	2
Community norms	4
Financial Oversight	3
Dataset Valuation Process	1
Open Data in Procurememnt	2
Open data strategy	4
Asset catalogue	5
Data release process	3
Standards development & adoption	5
Data governance	5
Managing sensitive data	5
Open data expertise	4
Knowledge management	4
Engagement process	2
Open data documentation	1
Re-user support processes	2
Community norms	1
Financial Oversight	3
Dataset Valuation Process	1
Open Data in Procurememnt	2
Open data strategy	3
Asset catalogue	5

Any idea? Tutorials? 

[v-frfei-msft]

Hi @steambucky ,

We can srot the visual by value as below.

For more details, please check the pbix as attached.

[steambucky]

Thanks, but I want to sort by placing the rows in an order of my choosing. I dont want sort them by numerical or alphabetical order. 

Anyone else have any idea? 

[Anonymous · Accepted solution]

Hi @steambucky ,

The only way we can do custom sorting in power bi is by creating conditional column in query editor or by creating new column using switch or if function,

I suggest you to create a conditional column in query editor on top of your dimension such as

In Query editor goto add column ->conditional column->choose column name. here in your case it's category.

Ex: Category ->equals->Data release process ->1

     Category ->equals->Standards development & adoption ->2

     ...

     ..

    Category ->equals->Asset catalouge ->30.

After creating conditional column save the changes in query editor and goto data view and choose the Category column ->Modelling->Sort by column->Custom Sort.

Then switch to report view and see the expected results.

Accept it as a solution if this works for you.