Custom Number Formatting with Unicode characters in Tableau
Vložit
- čas přidán 8. 09. 2024
- The formatting cheat sheet is linked below. Custom number formatting in Tableau provides lots of flexibility for displaying the same data in many different ways. See the two blog posts below for many examples with formatting codes you can copy and paste.
📑 Blog posts
Part 1: datavis.blog/2...
Part 2: datavis.blog/2...
Formatting Cheat Sheet
/ 1570143280704409600
Open in the image in a new tab for a hi-res, A4 sized image
▶ Subscribe for the latest tips and tutorials: bit.ly/Tableau...
🔗 Social Media
Blog: datavis.blog ➝ Tableau tips and tutorials
Twitter: / datavisblog ➝ Follow for new blog & video posts
Portfolio: public.tableau...
LinkedIn: / marcreiduk
Thanks for sharing, Marc! I didn't remember the positive | negative | neutral - cool stuff!
Thanks, Franco. Glad it's useful.
Thanks Marc, this I used to use very often and it is super helpful to know where it is.
Now, I do it the IBCS way to shrink the cognitive load: I declare the KPI and units in the title of each chart and do the in Thousands in Millions maths based on the window_avg.
Thanks for the comment, Matthias.
Thanks for sharing. How can we show negative values on "hh:mm:ss" format please ?
I think this forum post will help guide you in the right direction: community.tableau.com/s/question/0D54T00000C5yWvSAJ/time-difference-is-displayed-as-negative
Thank you for this tutorial, if i may ask, I have a data set with a column of values, some values has 1k , 2k and some normal decimal 500, 600, how do i normalise this column to be all decimal not string so i can apply calculations?
Hi - I'd recommend posting this question on the Tableau forums: community.tableau.com/s/explore-forums
Can we make a color logic for this symbols ? For example: green arrow - for positive, red - for negative. Or maybe some more difficult.
In text table only.
Dual axis tables are so bad :(
Hi, it's not possible directly in the formatting pane, unfortunately. However, you can achieve that effect using multiple calculations. e.g. in this blog: vizzingdata.com/tableau-tips-conditional-formatting-on-multiple-measures/