Last Modified Date: 30 Jul 2020
Environment
Tableau DesktopAnswer
Use a calculated field with IF/THEN conditions.For example, as in the attacked packaged workbook, if you have a dimension, Metric, with values A B C and D, and want the measure to be formatted as a percentage with A and B, but a float with C and D, you would create the following calculated field:
If [Metric]="A" or [Metric]="B"
Then
STR([Number]*100)+"%" else STR([Number])
End
Additional Information
It will usually be necessary to convert measures into strings in order to achieve this result.Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials