0
0
Tableaubi_tool~8 mins

Show Me panel for recommendations in Tableau - Dashboard Guide

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Dashboard Mode - Show Me panel for recommendations
Business Question

Which chart type best shows sales performance by product category and region?

Sample Data
Product CategoryRegionSalesProfit
FurnitureEast1000200
FurnitureWest1500300
TechnologyEast2000400
TechnologyWest2500500
Office SuppliesEast1200150
Office SuppliesWest1300180
Dashboard Components
  • KPI Card: Total Sales = SUM(Sales) = 9500
  • KPI Card: Total Profit = SUM(Profit) = 1730
  • Bar Chart: Sales by Product Category and Region
    Tableau "Show Me" recommended this chart when Product Category and Region are selected with Sales as measure.
  • Pie Chart: Profit distribution by Product Category
    Recommended by "Show Me" when Profit and Product Category are selected.
  • Data Table: Detailed sales and profit by Product Category and Region
Dashboard Layout
+----------------------+----------------------+
|      KPI: Sales      |      KPI: Profit     |
|      (9500)          |      (1730)          |
+----------------------+----------------------+
|                      Bar Chart: Sales by     |
|               Product Category and Region   |
|                                            |
+---------------------------------------------+
| Pie Chart: Profit by Product Category       |
+---------------------------------------------+
| Data Table: Sales and Profit Details        |
+---------------------------------------------+
Interactivity

Filters for Region and Product Category allow users to select specific areas or categories. All components update dynamically:

  • KPI cards recalculate totals based on filter.
  • Bar chart updates to show sales for selected categories and regions.
  • Pie chart adjusts profit distribution accordingly.
  • Data table shows filtered rows.
Self Check

If you add a filter for Region = East, which components update and what changes occur?

  • KPI cards show sales and profit only for East region (Sales = 4200, Profit = 750).
  • Bar chart shows sales by product category only for East.
  • Pie chart shows profit distribution for East region.
  • Data table filters to rows with Region = East.
Key Result
Dashboard shows sales and profit KPIs, bar and pie charts recommended by Tableau Show Me panel, with filters for region and product category.