KNOWLEDGE BASE

How To Label Specific Points Above A Reference Line


Published: 28 Feb 2020
Last Modified Date: 28 Feb 2020

Question

How to display label specific points above a reference line.
 

Environment

  • Tableau Desktop

Answer

To show labels for specific points above the reference line for view like below where the reference line value is 50000:
User-added image

1. Create a calculated field called All points above reference line with the following formula:

     IF SUM([Sales])>50000 then SUM([Sales]) end

2.  Create a calculated field called index with the following formula:

     IF NOT ISNULL( [all points above reference line]) then
     INDEX()
     END


3. Create a calculated field called Rank with the following formula:

     RANK([index], 'asc')

4. To show the first point above reference line, create a calculated field called Final Label with the following calculation:
     If [rank]=1 then ([all points above reference line]) END

5. Drag Final Label to Label on Marks Card 
 
Did this article resolve the issue?