Throughout my first week at the data school, I’ve gained a lot of insights into Tableau, including the power of parameters. They are a versatile tool that can take your charts to the next level. They let you swap dimensions or measures within a single chart, adding interactivity and depth to your visualisations. Imagine having a chart that users can adjust to view different aspects of your data—pretty exciting, right?
In this blog post, I’ll walk you through how to use parameters to enhance your dashboards. We’ll use the Superstore dataset as an example and create a line chart to display sales trends across the year from three different perspectives: by country, segment, and category. Here’s how you can do it:
- Create a Parameter
-
- Start by creating a parameter with a string data type and define a list of allowable values.
-
- After creating the parameter, make sure it’s visible on your dashboard. Right-click the parameter in the data pane and select “Show Parameter.”
- Create a Calculated Field for Swapping
-
- Use the CASE function to set up a calculated field that will allow you to swap views in your chart based on the selected parameter.
- Build the Chart
-
- Add the calculated field and sales measure to the rows, and place the order date (month) on the columns.
- For added clarity, you can drag the calculated field to the colour card to differentiate each category in your chart.
Now, you can effortlessly switch between views by selecting different options in the parameter control!
Thank you for reading! I hope this simple guide helps making your dashboards more interactive and insightful. If you’re curious to see how I’ve applied what I learned in my first week to improve my original dashboard, be sure to check out my Tableau page.
