KNOWLEDGE BASE

Sort Set Under Default Properties Reverts to Alphabetical with Live Connection to .csv File


Published: 31 Jan 2017
Last Modified Date: 10 Feb 2017

Issue

After changing the default sort of a calculated field, the field's sort reverts to alphabetical. 

Environment

  • Tableau Desktop 10.1.1
  • Text Files (Live Connection)

Resolution

Use one of the following workarounds:

Option 1: 

Use an extract. For more information, see Extract your Data

Option 2:

  1. Clear the default sort: 
    1. Right-click the field in the Dimensions pane and select Default Properties: Sort 
    2. Click Clear. 
  2. On each worksheet where the field is in use, right-click the field on the Columns or Rows shelf and select Sort 
  3. Sort as desired.

Cause

This behavior is related to a known issue which is currently under investigation. 
Did this article resolve the issue?