Change how a chart is sorted in a Power BI report
In a Power BI report, you can sort most visualizations alphabetically by the names of the categories in the chart, or by the numeric values of each category. For example, this chart is sorted by store name.
It's easy to change the sort from a category (store name) to a value (sales per square feet) instead.
- Select the ellipses (...) and choose Sort by Sales Per Sq Ft.
If necessary, select the sort icon to change to Descending.
NOTE: Not all visuals can be sorted. For example, the following visuals cannot be sorted: Treemap, Map, Filled Map, Scatter, Gauge, Card, Multi Row Card, Waterfall.
Sorting using other criteria
Sometimes, you want to sort your visual using a different field or other criteria. For example, you might want to sort by month (and not in alphabetical order) or you might want to sort by entire numbers instead of by digit (example, 0, 1, 9, 20 and not 0, 1, 20, 9).
In some cases, you may be able to sort the visual the way you'd like, for example, by month. But if not, it may be because the dataset behind the report needs some tweaking. Here are several solutions:
- In Power BI Desktop, use the Data Tools Modeling tab to sort by a different column.
- In Excel, if you own the dataset, add a new column that concatenates the month name and number. Then refresh or re-import the dataset to see the new column in the Fields area.
- In Excel, ensure that your numerical columns are tagged as "whole number" or "decimal" and not as "text."
More about Visualizations in Power BI reports.
More questions? Try the Power BI Community