Tableau tips: Dynamic Labelling of Number Values
This article is a recap of one of the previous article titled – Dynamic formatting of values. Basically, in this previous article we explored a ‘simple’ technique one could use to enable dynamic formatting of numbers – assuming numbers are ranging from small to large numbers, literally any natural number.
(The snapshot below is a sample data used in the previous article, which we’re going to use in this case too)
I must admit that the previous procedure was long and tedious. And therefore, in this article we’ll explore a simpler technique, inspired by a post written by Juan Manuel, a tableau consultant through his LinkedIn profile.
To demonstrate the practicality of this technique, let’s create a sample data as shown above, or you can download the data here to follow along.
The application of this technique is based on a single calculation which is applied as a label. Here is the calculation.
Once you’ve created this calculation field.
Drag dimension ID to the rows shelf
Drag the measure field Value to the rows shelf and convert it to a discrete value
Drag the calculated field created above -Dynamic Label - to the label shelf
Note: This will create a fully formatted view, with numbers labelled appropriately according to the customization of the calculation above.
Note: In the same way, this technique can be applied in other form of visualization by using the calculated field - Dynamic Label - as a label.
I know you MUST admit that this technique is much simpler when compared with the previous article.
Thanks for reading.