Custom Number Formatting with Unicode characters in Tableau

Sdílet
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

Komentáře • 10

  • @PatrickBateman12420
    @PatrickBateman12420 Před 2 lety +1

    Thanks for sharing, Marc! I didn't remember the positive | negative | neutral - cool stuff!

    • @MarcReid
      @MarcReid  Před 2 lety

      Thanks, Franco. Glad it's useful.

  • @matthiasgiger1875
    @matthiasgiger1875 Před 2 lety +1

    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.

    • @MarcReid
      @MarcReid  Před 2 lety

      Thanks for the comment, Matthias.

  • @Bobby-dz6xi
    @Bobby-dz6xi Před rokem

    Thanks for sharing. How can we show negative values on "hh:mm:ss" format please ?

    • @MarcReid
      @MarcReid  Před rokem

      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

  • @SillyEngineer
    @SillyEngineer Před 11 měsíci

    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?

    • @MarcReid
      @MarcReid  Před 11 měsíci

      Hi - I'd recommend posting this question on the Tableau forums: community.tableau.com/s/explore-forums

  • @f1r3shoot
    @f1r3shoot Před rokem

    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 :(

    • @MarcReid
      @MarcReid  Před rokem

      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/