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.

  1. Select the ellipses (...) and choose Sort by Sales Per Sq Ft.
  2. 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."

Next steps

More about Visualizations in Power BI reports.

Power BI - Basic Concepts

More questions? Try the Power BI Community