Sorting columns with display values
If you define display values, data in visualizations that use them will, by default, be sorted by the alphabetical order of the display values. However, it is also possible to use display values but to show the data sorted by the original values. This gives you the opportunity to, for example, sort the bars in a bar chart by another column, or using a custom expression.
About this task
Note: When you sort data
based on the display values, this is a purely visual change; any calculations
are always based on the original values. If you add any expressions that rely
on the order of the data, such as OVER expressions, the sorting will always be
based on the original values (regardless of what has been selected in the
Display values dialog).
Before you begin
Procedure
-
On the
authoring bar, click
Data in analysis
and click on the column of
interest.
That is, select the column that you have modified display values for, and want to update the sorting on. -
In the expanded flyout,
make sure that
Details on selected column
is selected.
-
In the lower part of the expanded flyout, click the settings
button next to
Display values
.