5 Replies Latest reply on Aug 31, 2018 11:15 AM by Kurt Heisler

# Suppress / hide some marks on a line

This tutorial shows how to use a dual axis to highlight certain marks on a line: Highlighting Points in a Line Graph — OneNumber. The example uses a simple calculated field which you drag onto the color card for the second axis (which are circles).

In a case like this, is there way to hide/suppress the marks that are not highlighted? Using this example, if I change the color of those marks to white, it creates white circles instead of gray ones. If I ask the calculated field to return Null for those marks, Tableau still requires me to assign a color to Null. I would like to suppress the marks completely.

• ###### 1. Re: Suppress / hide some marks on a line

In That case, in your data for Circles you should plot non-null values only by filtering.

• ###### 2. Re: Suppress / hide some marks on a line

You could create a calculated field that only returns values that meet your mark criteria and use that on your secondary axis.

if sum([Profit]) < 0 then sum([Profit]) END

1 of 1 people found this helpful
• ###### 3. Re: Suppress / hide some marks on a line

Instead of using another Profit Ratio for dual axis, use this calculation:

IF [Calculation1] = "YES" Then [Profit Ratio] ELSE NULL END

>> Synchronize Axis

Your [Calculation1] is:

IF RANK(-[Profit Ratio]) <=5 THEN "YES" ELSE "No" END

- which you used in Color mark with your example.

• ###### 4. Re: Suppress / hide some marks on a line

HI Kurt,

You can alter the calculation for "Bottom 5 Day?" as shown below

Bottom 5 = if RANK(-[profit ratio])<=5 then [profit ratio] END 2 of 2 people found this helpful
• ###### 5. Re: Suppress / hide some marks on a line

Thanks!