3 Replies Latest reply on Jun 8, 2018 9:26 AM by Sohan Jawar

    Conditional formatting of 0 values to blanks

    Siebe Weersma

      Hi all,

       

      I have a workbook with (positive and negative) values that are shown as millions [ #,##0,,M;-#,##0,,M ], such that €1.000.000 is shown as 1M

      Now, €400.000 is shown as 0M, while 0 is also shown as €0M. I wish the latter to be shown as blanks.

       

      In different threads I saw the solution for formatting should be to adjust the custom format to [ #,##0,,M;-#,##0,,M;"" ].

      When I do this, the values of €400.000 are also blank, instead of 0M, Thus it appears that Tableau firstly rounds the numbers, and then applies the formatting.

      Is there a way to obtain the format as described above - preferably without using calculated fields, as there are multiple measures with the same issue.

       

      Thanks in advance!

       

      In short:

      Value              Desired formatCurrent (#,##0,,M;-#,##0,,M)Tried (#,##0,,M;-#,##0,,M;"")
      -1.000.000-1M-1M-1M
      -100.000-0M-0Mblank
      0blank0Mblank
      100.0000M0Mblank
      1.000.0001M1M1M

       

      (Tableau version 10.4)