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

Question

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

Environment

Tableau Desktop

Answer

1. Create the following 2 parameters: Slaes_lower limit, Selected Date

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

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.