Skip to main content

Hello,

 

I have several measures that I am switching between (with a parameter ...for an example see below), and when I do this, the formatting for the field is no longer applied.  Is there a way to "pass" he formatting for field through the calculated field??  Any help would be greatly appreciated.

 

   Example:

                    Calculated field --

                   

                    Case [Measure Selector]

                    When "1" then [measure 1]

                    When "2" then [measure 2]

                    When "3" then [measure 3]

                    END

 

Jake

3 answers
  1. Jan 6, 2015, 11:07 PM

    The underlying formats can't apply because the calc field is its own entity, and it has its own format.

     

    Until Tableau does something different, consider making the final output of the calc field a string variable, and instead of just setting the calc to the measure selected, also format it within the string.

     

    Messy?  Tedious?  No doubt.  But it will get you where you need to go.

0/9000