Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
Hi @steambucky ,
We can srot the visual by value as below.
For more details, please check the pbix as attached.
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?
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.
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |