• Bernard

Tableau tips: Dynamic Labelling of Number Values

Updated: Sep 3, 2020

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. I believe this article was helpful to you. To receive more of the Tableau tips and tricks, kindly join our mailing list by subscribing below.

Thank you for reading.


Top 35 Data Visualization Widgets

Take your data visualization skills to the next level with this FREE guide!!

FREE Tableau Desktop Course for Beginners

Get started with Tableau, a data visualization tool that allows you connect to nearly any data and create interactive visualizations.