In this article, we will show you, How to Sort a Chart in Power BI with an example. To demonstrate the same, we are going to use the Column Chart that we created earlier. Please refer Column Chart in Power BI article to understand the column chart creation.
How to Sort a Chart in Power BI Example
By default, every chart is sorted by the Metric Value (Numeric Value). Please click on the … (3 dots) on the top right corner, to see the Sorting column.
From the below screenshot, you can see that the chart is sorted by the Sales Amount in Descending Order.
If you want to Sort by Sales Amount in Ascending order then click on the left corner (the place where we marked)
Now you can see, the chart is sorted by Sales Amount in Ascending Order
If you want to use the Dimension field (or any other field) as the sort option then you select that field. Let me select the Sort by Color option
As you can see that the chart is sorted by color in descending order (default order)
You can click on the marked section to sort the chart by color in ascending order
For example, if your chart has more than two fields then you can sort by any of those three fields. From the below Line Chart, you can sort by State Province Name, Sales Amount, or Total Product Cost
Thank You for Visiting Our Blog