How To Click One Mark To Show The Lines That Have Values Above That Mark

Published: 02 Jun 2023
Last Modified Date: 05 Jun 2023


How to click one mark to show the lines that have values above that mark?


  • Tableau Desktop 


1. Create the following 2 parameters: Slaes_lower limitSelected Date
User-added image

User-added image

2. Right click the parameter Sales_lower limit, and select Show Parameter
3. Create the following calculation field filter
{fixed [Sub-Category]:sum(
    if DATETRUNC('month', [Order Date])=DATETRUNC('month', [Selected Date]) 
    then [Sales] END
>=[Sales_lower limit]-1

4. Add filter to the Filters card, and select True
5. Select from the menu bar Worksheet > Actions... > Add Action Change Parameter..., add the following 2 actions.
User-added image
User-added image

6. Select a mark in the line graphs, confirm only the lines with marks above the selected mark in that month are shown in the view.
*To reset the view, please enter a value that's lower than the lowest value in parameter Sales_lower limit.
Did this article resolve the issue?