Master Tableau From Scratch

Learn Tableau fundamentals, data connections, data preparation, filtering, data modeling, calculations, LOD expressions, visualizations, dashboards, and storytelling through structured practical lessons.

COURSE SYLLABUS

Show Me Feature in Tableau

Learn how to use the Show Me feature in Tableau to explore different visualization types and select suitable charts based on dimensions, measures and data requirements. Understand chart recommendations, field selection, visualization configuration and practical examples.

1. Introduction to Show Me in Tableau

Show Me is a built-in feature in Tableau that helps users discover and create different types of visualizations. It provides a collection of chart options based on the fields selected from the Data Pane.

Instead of manually experimenting with every chart type, users can select the required dimensions and measures and open the Show Me panel. Tableau highlights visualization types that are supported by the selected fields.

For example, if a user selects Category and Sales, Tableau may recommend a bar chart. If the user selects two numerical measures, Tableau may offer a scatter plot, provided the required fields and data structure are suitable.

Why is Show Me useful?

  • Helps users discover available chart types.
  • Provides visualization recommendations based on selected fields.
  • Reduces the effort required to create common charts.
  • Helps beginners understand different visualization options.
  • Supports quick exploration of datasets.
  • Allows users to experiment with alternative chart representations.

2. Understanding the Show Me Panel

The Show Me panel is available in the Tableau worksheet interface. It contains different visualization options that users can select according to their analytical requirements.

The panel evaluates the selected fields and indicates which chart types can be created with the current selection. Some chart options may be available while others may remain unavailable until the required field types are selected.

Important Components

Component Description
Data Pane Contains dimensions, measures and available fields from the data source.
Selected Fields Fields selected by the user for creating a visualization.
Show Me Panel Displays available visualization options.
Chart Recommendations Highlights chart types supported by the selected fields.
Worksheet View Displays the visualization generated after selecting a chart type.
Marks Card Allows further customization of the generated visualization.
Data Pane Dimensions Category Region Order Date Measures Sales Profit Quantity Worksheet View Generated Chart Show Me Bar Line Pie Area Scatter Map Chart Options Based on selected fields
Simplified illustration of the Tableau worksheet and Show Me panel.

3. How Does Show Me Work?

Show Me uses the fields selected by the user to determine which visualization types are appropriate. It considers field roles, data types and the requirements of different chart types.

For example, a bar chart commonly requires a categorical dimension and a measure. A line chart is often used with a date or ordered dimension and a measure. A scatter plot generally requires two numerical measures.

Basic Workflow

  1. Open a Tableau worksheet.
  2. Review the available fields in the Data Pane.
  3. Select the dimensions and measures required for analysis.
  4. Open the Show Me panel.
  5. Review the available and highlighted chart types.
  6. Select a suitable visualization.
  7. Tableau generates the chart when the field requirements are met.
  8. Customize the visualization using Rows, Columns, Marks Card and Filters.
Select Fields Open Show Me Choose Chart Generate View Customize Chart
Basic workflow for creating a visualization using Show Me.

4. Chart Types Available in Show Me

Show Me provides several visualization options. The available choices depend on the selected fields and the data requirements of each visualization.

Chart Type Purpose Typical Field Requirements
Text Table Displays exact values in rows and columns. Dimensions and measures.
Bar Chart Compares values across categories. A dimension and a measure.
Line Chart Displays trends and changes over an ordered sequence. An ordered or date dimension and a measure.
Area Chart Displays magnitude and trends over time or an ordered dimension. An appropriate ordered dimension and measure.
Pie Chart Shows the contribution of categories to a whole. A dimension and a measure.
Scatter Plot Explores relationships between numerical variables. Two numerical measures, with dimensions for additional detail if needed.
Histogram Displays the distribution of numerical values. A numerical measure and generated bins.
Highlight Table Displays tabular values with color emphasis. Dimensions and a measure.
Heat Map Shows patterns using color and mark size. Dimensions and one or more measures.
Symbol Map Displays geographic locations using symbols. Geographic fields and optional measures.
Filled Map Colors geographic areas based on a measure. Supported geographic fields and a measure.
Note: The table describes typical requirements, not an exhaustive list of every Show Me rule. Tableau may require additional fields or a particular data structure for some chart types.

5. Understanding Field Requirements

Every visualization has its own data requirements. Show Me uses the selected fields to determine whether a chart can be created. Understanding these requirements helps users select the right fields.

Dimensions and Measures

Dimensions generally represent descriptive information, such as Category, Region, Product Name and Customer Name. Measures generally represent numeric values, such as Sales, Profit, Quantity and Discount.

Field Data Role Example Use
Category Dimension Compare product categories.
Region Dimension Analyze regional performance.
Order Date Date Dimension Analyze monthly trends.
Sales Measure Measure revenue performance.
Profit Measure Analyze profitability.
Quantity Measure Compare units sold.

Example Field Combinations

Selected Fields Possible Visualization Business Question
Category + Sales Bar Chart Which category generates more sales?
Order Date + Sales Line Chart How do sales change over time?
Sales + Profit Scatter Plot How are sales and profit related?
Region + Category + Sales Highlight Table Which region-category combinations perform better?
Customer Age Histogram How are customer ages distributed?

6. How to Select the Right Chart Using Show Me

Selecting a chart should begin with the business question, not simply with the available chart icons. Show Me helps identify possible chart types, but users must still decide which visualization communicates the information most clearly.

Step-by-Step Chart Selection

  1. Identify the business question you want to answer.
  2. Determine whether you need comparison, trend, distribution, relationship or composition analysis.
  3. Identify the required dimensions and measures.
  4. Select the appropriate fields in the Data Pane.
  5. Open Show Me and review the highlighted chart options.
  6. Select a chart that supports your analytical objective.
  7. Review the result and check the aggregation.
  8. Customize labels, colors, titles and tooltips.

Business Questions and Chart Selection

Business Question Recommended Chart Reason
Which region has the highest sales? Bar Chart Easy category comparison.
How are sales changing every month? Line Chart Shows changes over time.
How are sales and profit related? Scatter Plot Displays relationships between measures.
What percentage of sales comes from each category? Pie Chart or Bar Chart Shows contribution to a total.
Which region-category combination has higher sales? Highlight Table Compares values using color emphasis.
How are customer ages distributed? Histogram Shows frequency across numerical intervals.

7. Practical Example: Create a Bar Chart Using Show Me

In this example, we will create a bar chart to compare sales across product categories. The dataset should contain Category and Sales fields.

Sample Dataset

Category Sales
Technology85,000
Furniture62,000
Office Supplies48,000
Accessories35,000

Steps

  1. Open Tableau and connect to the sample sales dataset.
  2. Open a new worksheet.
  3. Locate Category in the Dimensions section.
  4. Locate Sales in the Measures section.
  5. Select Category and Sales from the Data Pane.
  6. Open the Show Me panel.
  7. Select the Bar Chart option if it is available.
  8. Tableau generates the visualization.
  9. Drag Sales to Label if you want to show exact values.
  10. Sort the bars to make the sales ranking easier to understand.
  11. Rename the worksheet to Category Sales Analysis.
Category Sales Analysis 85,000 62,000 48,000 35,000 Technology Furniture Supplies Accessories
Illustrative bar chart generated from Category and Sales fields.

8. Practical Example: Create a Line Chart Using Show Me

In this example, we will analyze monthly sales trends using Order Date and Sales. A line chart helps users identify increases, decreases and fluctuations in sales over time.

Sample Dataset

Month Sales
January20,000
February25,000
March22,000
April32,000
May38,000
June35,000

Steps

  1. Open the sales dataset in Tableau.
  2. Open a new worksheet.
  3. Select Order Date and Sales from the Data Pane.
  4. Open the Show Me panel.
  5. Select Line Chart if the selected fields support it.
  6. Review the date level used on the horizontal axis.
  7. Choose Month if monthly analysis is required.
  8. Use the Marks Card to customize the line and its appearance.
  9. Add Sales to Tooltip or Label when required.
  10. Rename the worksheet to Monthly Sales Trend.
Monthly Sales Trend Jan Feb Mar Apr May Jun
Illustrative monthly sales line chart.

9. Customizing Charts Created Through Show Me

Show Me creates a starting visualization, but users can further customize the chart using Tableau worksheet shelves and cards. Customization helps make the visualization more meaningful and easier to understand.

Important Customization Options

Option Purpose Example
Rows Controls fields displayed vertically. Sales on Rows.
Columns Controls fields displayed horizontally. Category on Columns.
Color Uses colors to distinguish values or categories. Color by Region.
Size Controls the size of marks. Size by Profit.
Label Displays values directly on the chart. Show Sales on bars.
Tooltip Displays details when hovering over marks. Show Category and Sales.
Filters Limits the data displayed. Show only the West region.

Example: Customize a Bar Chart

  1. Create a bar chart using Show Me.
  2. Drag Region to Color.
  3. Drag Sales to Label.
  4. Use the Marks Card to adjust the bar appearance.
  5. Drag Order Date to Filters if a date-based restriction is required.
  6. Format Sales as currency if the measure represents monetary values.
  7. Update the worksheet title to describe the analysis.

10. Show Me vs Manual Chart Creation

Tableau allows users to create visualizations through Show Me or by manually placing fields on the Rows and Columns shelves and configuring the Marks Card. Both approaches are useful, depending on the user's experience and analytical requirements.

Feature Show Me Manual Creation
Approach Select fields and choose a chart recommendation. Place fields directly on shelves and cards.
Ease of Use Helpful for beginners and quick exploration. Requires understanding of Tableau shelves and marks.
Chart Selection Provides available visualization options. User decides the mark type and field arrangement.
Customization Generated chart can be customized further. Provides direct control while building the view.
Flexibility Useful for supported standard visualizations. Useful for more specific or customized views.
Best Practice: Use Show Me to explore possible chart types. Use manual field placement when you need more direct control over the worksheet structure.

11. Common Problems When Using Show Me

Problem Possible Reason Recommended Solution
Chart option is unavailable Selected fields do not meet the chart requirements. Select the required dimensions or measures.
Unexpected chart appears Selected fields or their data roles differ from the intended analysis. Review the field selection and choose another chart type.
Chart displays aggregated values Tableau is aggregating measures. Check the measure aggregation and level of detail.
Date chart looks incorrect Incorrect date level or date role is being used. Review the date field and select the appropriate date level.
Scatter plot has too few marks Measures may be aggregated into fewer points. Add an appropriate dimension to Detail when individual marks are required.
Chart is difficult to read Too many fields, colors or labels are included. Simplify the visualization and format it carefully.

12. Best Practices for Using Show Me

  • Understand the business question before selecting a chart.
  • Check dimensions and measures before opening Show Me.
  • Select only the fields required for the analysis.
  • Review chart requirements before choosing a visualization.
  • Use suitable chart types for comparisons, trends and relationships.
  • Verify measure aggregation after creating the chart.
  • Use clear titles and meaningful labels.
  • Avoid unnecessary colors and visual effects.
  • Customize tooltips to provide useful information.
  • Use manual chart creation when more control is required.
  • Review the final chart before adding it to a dashboard.

13. Practical Exercise: Build a Sales Analysis Workbook

In this exercise, create multiple worksheets using the Show Me feature and analyze a sample business dataset. The dataset should contain Order Date, Category, Region, Sales, Profit and Quantity.

Task 1: Category Sales Comparison

  1. Select Category and Sales.
  2. Open Show Me.
  3. Create a Bar Chart.
  4. Sort the categories by sales.
  5. Display values on the bars.

Task 2: Monthly Sales Trend

  1. Select Order Date and Sales.
  2. Choose a Line Chart.
  3. Set the date level to Month.
  4. Review the sales trend.
  5. Add a meaningful worksheet title.

Task 3: Sales and Profit Relationship

  1. Select Sales and Profit.
  2. Choose a Scatter Plot if available.
  3. Add a suitable dimension to Detail if individual records are required.
  4. Use Color to distinguish Region.
  5. Review the relationship between the two measures.

Task 4: Regional Sales Highlight Table

  1. Select Region, Category and Sales.
  2. Choose Highlight Table if available.
  3. Review the color scale.
  4. Check the displayed values.
  5. Identify high and low performing combinations.

Expected Learning Outcome

After completing this exercise, you should understand how to select fields, use Show Me recommendations, create different visualizations, customize chart properties and choose an appropriate chart for a business question.

Summary

Show Me is a useful Tableau feature that helps users discover and create visualizations based on selected dimensions and measures. It provides chart options such as bar charts, line charts, pie charts, scatter plots, histograms, highlight tables and maps when the selected fields satisfy the required conditions. Users can select suitable fields, review available recommendations, generate a chart and customize it using Rows, Columns, the Marks Card and Filters. Show Me makes chart exploration easier, while understanding the data structure, business question and chart requirements remains important for creating accurate and meaningful visualizations.