Strengthen Your Dashboards with Parameters


What are parameters?

Parameters are a workbook variable that is defined as a number, date or string. It can act as a filter, reference or replace a value in your data source. With parameters you can also create ‘parameter actions’ that let’s the user dynamically change set parameters when interacting with the viz.

I like to use parameters when creating a dashboards with multiple data sources. I also use parameters to activate different views when I use parameters as filters. Keep in mind, I still make every effort to process my data into one large dataset (in practice) during my ETL phase; but sometimes when I am tasked with multiple data sets in the dashboard build phase, I will incorporate with parameters.

Using the superstore sales dataset I create a quick dashboard where I do the following with parameters:

  • Change views
  • Use as a filter
  • Interact as a reference line
  • Change a calculation
  • Use in a parameter action

I hope that by viewing the below video this will get those creative juices flowing to start using parameters in your dashboard builds.

Enjoy and remember any feedback is welcome!

Leave a comment