A picture is worth 1,000 words, but a one-minute, 30-FPS video is worth 1,800 pictures—which means as you increase the dimension, you get more information at the cost of increased complexity.
When you are up for a presentation, it is important to understand what kind of media you put on your slides. When you present results to stakeholders and clients, you need to precisely and concisely convey important information. You can fill your Powerpoint slides with text and some images, but is that the most efficient way to present your insights? Maybe, maybe not! If you convert your images from static to dynamic, they can convey a lot more information while also hiding unnecessary information.
In this guide, you will learn how to create dynamic charts in Tableau that contain additional information and yet display only what is asked for.
Consider a bar chart that consists of hundreds of bars. All of these bars can be adjusted in a single view, but nobody can recognize the labels associated with them due to overlapping text. Instead, when you have a lot of bars, a better option is to visualize only each bar and the data associated with it one at a time.
To try this in Tableau, start with the Sample - Superstore dataset. In your worksheet, drag and drop the Profit and Sales measures to columns and the Sub-Category dimension to rows. These actions will result in the following chart:
The chart displays the profit and sales of each product sub-category. To visualize only one product's profit and sales, right-click on Sub-Category from the data pane and select Show Filter. This will open up a new card on the right side of the sheet:
To display details of only one product at a time, first, click on (All), which will deselect all the sub-categories. Next, select the name of any category, here, Phones.
When you have hundreds of product names inside the card and you find it difficult to search for a specific product name, you can always use the Find Values option. This option lets you type the name of the product instead of manually searching for it.
How can you present information from multiple charts in the same area? Maybe you can use dual-axis charts that combine data of multiple time-series into one chart, or maybe you can go for sub-plotting! Most people find the dual-axis plot a little difficult to understand due to multiple magnitudes sharing the same space. As far as sub-plotting is concerned, four to nine sub-plots work in a chart, but increasing the number to 20, 40, and so on only diminishes the size of each sub-plot.
A better solution to visualize multiple plots in a single chart is to place a drop-down list next to the chart and let users select which plot they want to visualize. This way you get a properly sized chart without the confusion of multiple magnitudes mixing together.
To create a dynamic dashboard, load the Sample - Superstore dataset in Tableau. You will be creating three charts, each representing one of the following relationships:
Drag and drop Profit to the Columns shelf followed by State, City, or Postal Code to the Rows shelf, one in each of the three sheets. If you wish, you can rename the charts in each sheet.
Next, create a new string parameter, Specify a Location, with a list of three values (State, City, Postal Code). Remember that the names of the Value and Display As columns are same, as shown:
With the parameter in its place, create a new calculated field with the same name as the parameter:
Now, go to each of the three sheets and perform these steps:
With the above operations complete, you can move ahead to create a dashboard. Once on the dashboard, drag and drop the horizontal layout object in the blank white space. Next, drag and drop each of the three sheets in the dashboard working area and hide the title of each sheet, if needed. This completes the creation of a dynamic chart in Tableau.
To visualize the chart, open the dashboard in a presentation view and let the user select an option. Below is a preview of the "Profit in each State" chart:
Tableau has a built-in labeling feature that lets you view the details of your chart just by hovering the mouse. You can further increase the productivity of your charts by either providing a filter to display only one out of many features or toggling between charts using a drop-down menu. This guide has explained both of these methods. You can learn more about creating dynamic Tableau charts from this blog.