Forum Discussion
sort by multiple criteria
In Power BI Desktop, I am able to sort by multiple criteria when I set it up in a table first and then create a graph. However, when I create a bar chart, drill down to change it to a table and set the sorting, and then change it back to a bar chart, the sorting is not reflected. How can I sort by multiple criteria in this case?
Hi sugar_sugar - In the data model view, create a new calculated column:.
Sort your data by the new SortKey column.
SortKey = [Category] & "-" & [SubCategory]
Sort your data by the new SortKey column.
Apply the sort in a bar chart:
- Add the Product,Category,Subcategory and Value columns to your bar chart.
- Select the bar chart visual, go to the Visualization pane, and find the Sort by dropdown.
- Choose SortKey from the dropdown to sort by your custom column.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
2 Replies
Hi sugar_sugar - In the data model view, create a new calculated column:.
Sort your data by the new SortKey column.
SortKey = [Category] & "-" & [SubCategory]
Sort your data by the new SortKey column.
Apply the sort in a bar chart:
- Add the Product,Category,Subcategory and Value columns to your bar chart.
- Select the bar chart visual, go to the Visualization pane, and find the Sort by dropdown.
- Choose SortKey from the dropdown to sort by your custom column.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Thank you for your reply!
I understand that creating a sort key is the most reliable method.
By the way, is it possible to use these sorting conditions? (Sorry for the image in Japane)
