Annual Calendar in Tableau - 4. Two Colours for Two Different Fields

Question 1: How can we display both Sales and Profit on the same calendar?

Step 1: Create a parameter for users to switch between Sales and Profit

Step 2: Create a calculated field to apply the parameter in the view

Step 3: Put it on the colour shelf

Questions 2:  Can we use different colours for Sales and Profit?

Step 1: Create a calculated filed = the Parameter

Step 2: Put it on the colour shelf

But now we’ve lost our colour gradient…

Questions 3: What is the easiest way to show Sales and Profit in different (gradient) colours?

Step 1: Put the Parameter on the Filter Shelf

Step 2: Duplicate the sheet, edit the Filter, add Sales in the Customer Value List

Step 3: Put SUM(Profit) and SUM(Sales) on the Colour shelves respectively

Step 4: Create a new Dashboard, put two worksheets one top of the other with exactly the same Position and Size.

https://public.tableau.com/views/ProfitSalesCalendarTemplate/ProfitorSales?:display_count=y&:origin=viz_share_link

Author:
Sijia Wei
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab