Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
96 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |