The Sales in the South bar chart automatically updates to show just the sub-category sales in the selected state. Select a state within the Southern region of the map. Select Profit Map in the dashboard, and click the Use as filter icon in the upper right corner. Wouldn't it be great if you could view which sub-categories are profitable in specific states? Click the drop-down arrow at the top of the Year of Order Date filter, and select Single Value (Slider).That's nice, but it could be made even easier to compare. Your data is quickly filtered to show that state performance varies year by year. Try selecting different years on the Year of Order Date filter. In this example, it is placed just off the East Coast, in the Atlantic Ocean. Move it to the white space in the map view. Repeat this step for the second Sub-Category filter card and one of the Year of Order Date filter cards.Ĭlick on the Profit color legend and drag it from the right to below Sales in the South.įinally, select the remaining Year of Order Date filter, click its drop-down arrow, and then select Floating. Select the first Sub-Category filter card on the right side of your view, and at the top of the card, click the Remove icon. Repeat this step for the Sales in the South view title.The title Profit Map is hidden from the dashboard and even more space is created. Right-click the Profit Map title and select Hide Title. The extra space makes it easier to see data on your dashboard, but let's freshen things up even more. You've now hidden unnecessary columns and rows from your dashboard while preserving the breakdown of your data.

Repeat this process for the Category row header. On Sales in the South, right-click in the column area under the Region column header, and clear Show header. Resolving these issues will give you more room to communicate the information you need. Also, because we have the map in view, we probably don't need the South region column in Sales in the South, either. It's not easy to see details for each item under Sub-Category from your Sales in the South bar chart. Drag Sales in the South to your empty dashboard.ĭrag Profit Map to your dashboard, and drop it on top of the Sales in the South view.īut sadly, the bar chart is a bit squished, which isn’t helping your boss understand your data. In the Dashboard pane on the left, you'll see the sheets that you created. Your bar graph view of profit and your map view demonstrate this point nicely.

You want to emphasize that certain items sold in certain places are doing poorly. To do this, you can use dashboards to display multiple worksheets at once, and-if you want-make them interact with one another. Now you need a way to show the negative profits in Tennessee, North Carolina, and Florida and explain some of the reasons why profits are low. You’ve created four worksheets, and they're communicating important information that your boss needs to know.

Best spatial tableau public dashboards