top of page

Tableau tips: Dynamic Labelling of Number Values

Updated: Aug 18, 2021

Dynamic labelling of values in Tableau

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.

Black & white.jpg

About Me

More About the Author

Bernard K

Analytics Consultant | 3X Tableau Certified

Bernard is a data analytics consultant helping businesses reveal the true power of their data and bring clarity to their reporting dashboards. He loves building things and sharing knowledge on how to build dashboards that drive better outcomes.

Let’s discuss your data challenges! Let’s work together!

bottom of page