KNOWLEDGE BASE

Sorting a Legend Independently from the Order of Fields in a View


Published: 15 Jul 2013
Last Modified Date: 18 Sep 2017

Issue

The fields in the color legend of a worksheet cannot be sorted in a different order than the dimension fields reflected in the view.

Environment

Tableau Desktop

Resolution

Use the workaround below:
  1. Right-click on the field to be sorted in the Dimensions pane and select Duplicate.
  2. Add the duplicate field to the Color shelf.
  3. Drag the original field onto the Rows or Columns shelf as necessary.
  4. Sort the original field as desired for the visualization, and then sort the duplicate field as desired for the color legend.

Cause

The color legend contents are based on the way the dimension fields are sorted in the visualization.
Did this article resolve the issue?