Dynamic Number Formatting By Rody Zacovich

Want to Get Latest Updates and Tips on Tableau Bites Blogs

Picture 82

Recently I saw some examples of Dynamic Number Formatting on Twitter, so I though I’d share a solution I came up with a few years ago.This solution uses some simple math to determine the base 10 of a number. Using that base 10 we can determine how to round it, and which numeric symbol it should have. Solution also removes 0 decimals, and handles negatives.Copy/Paste this calc and change [Value] to the field you want to have dynamically formatted. NOTE* we are aggregating in the calc, so if you want to dynamically display a value that is MAX/MIN/AVG/ETC, change the aggregation in the formula.

Read Original Article…

Share This Post:

001 database

Tableau Training on
Tap Fast Track

data scientist 1

Tableau Advanced Analyst

002 bar chart


003 network

Tableau Training
on Tap

Share :

Leave a Comment

Your email address will not be published. Required fields are marked *