KNOWLEDGE BASE

Unable to Change Number Format When Using Parameters to Swap Measures


Published: 18 Jun 2013
Last Modified Date: 11 Jul 2016

Issue

When you use a parameter to swap measures in the view, the number formatting does not change based on the selected measure. 

Environment

Tableau Desktop

Resolution

If you want one measure to display as a percentage and a second measure to display as currency, use the following workaround:
  1. Use a calculated field to convert the measures to strings, and then format the strings within the calculated field. The following formula provides a template that can be used for the calculated field:
    CASE [<Measure Swapping Parameter>] 
    WHEN '<Measure A>' THEN LEFT(STR(AVG([<Measure A>])*100), 3) + "%" 
    WHEN '<Measure B>' then "$" 
    + (if SUM([<Measure B>])>99999 THEN LEFT(STR(SUM([<Measure B>])), 3) 
    + "," + MID(STR(SUM([<Measure B>])), 4, 3) END) 
    END
  2. In the view, replace the parameter with the newly created calculated field.

Cause

When measures are used in a parameter, the calculated field that generates the measure values for the parameter is considered a single field. As a result, it is not possible to format the individual measure values used in the parameter.
Did this article resolve the issue?