By Michele Hart
Tuesday, January 17, 2017
In Power BI, you can sort charts 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 sort it from highest to lowest 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. The following visuals cannot be sorted: Treemap, Map, Filled Map, Scatter, Gauge, Card, Multi Row Card, Waterfall.
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 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