Filter actions send information between worksheets. Typically, a filter action sends information from a selected mark to another sheet showing related information. Behind the scenes, filter actions send data values from the relevant source fields as filters to the target sheet.
The first action will filter the customer sheet per Subcategory, measure selected and hide the customer sheet when nothing is selected. The second action will keep only the selected sub-category (filter source sheet) subcategories – subcategories (select and show all values).
We can use this method in order to save more space in our dashboard.
→ Create a sheet with SUM(Sales) and SUM(Sales) on columns and Sub-Category on rows. Add each measure on each card on color and label.
→ Create a sheet with Measure Names on columns and Customer Name on rows. Bring the Measure Names on filter and keep only Profit and Sales. Add Measure Values on Label and Color. Choose from the Mark: Square.
→ Ensure that each worksheet is on ‘Fit Width’ mode.
→ Add the first filter action:
Dashboard actions → Source Sheets: Subcategory (Dashboard) → Run Action on Select → Target Sheets: Customer (Dashboard) → Clearing the selection will: Exclude all values
→ Add the second filter action:
Dashboard actions → Source Sheets: Subcategory (Dashboard) → Run Action on: Select → Target Sheets: Subcategory (Sheet) → Clearing the selection will: Show all values.
Watch the video tutorial here:
We hold all possible technical and sales certifications for all products:
Tableau Desktop, Tableau Public, Tableau Server, Tableau Prep, and Tableau Data Management.
With Tableau Software – the best data visualization platform – you can always understand your business or your job better. Using Tableau, you will take smart and strategic decisions and you will quickly understand the data flow, numbers and the results it produces. See other #skillpill video tutorials here:
Are you interested in learning more about Tableau Software – one of the best analytics tools and implementing the solution in the entire company?
See how Tableau works, by downloading a free trial here: