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. |
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
- Open a Tableau worksheet.
- Review the available fields in the Data Pane.
- Select the dimensions and measures required for analysis.
- Open the Show Me panel.
- Review the available and highlighted chart types.
- Select a suitable visualization.
- Tableau generates the chart when the field requirements are met.
- Customize the visualization using Rows, Columns, Marks Card and Filters.
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. |
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
- Identify the business question you want to answer.
- Determine whether you need comparison, trend, distribution, relationship or composition analysis.
- Identify the required dimensions and measures.
- Select the appropriate fields in the Data Pane.
- Open Show Me and review the highlighted chart options.
- Select a chart that supports your analytical objective.
- Review the result and check the aggregation.
- 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 |
|---|---|
| Technology | 85,000 |
| Furniture | 62,000 |
| Office Supplies | 48,000 |
| Accessories | 35,000 |
Steps
- Open Tableau and connect to the sample sales dataset.
- Open a new worksheet.
- Locate Category in the Dimensions section.
- Locate Sales in the Measures section.
- Select Category and Sales from the Data Pane.
- Open the Show Me panel.
- Select the Bar Chart option if it is available.
- Tableau generates the visualization.
- Drag Sales to Label if you want to show exact values.
- Sort the bars to make the sales ranking easier to understand.
- Rename the worksheet to Category Sales Analysis.
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 |
|---|---|
| January | 20,000 |
| February | 25,000 |
| March | 22,000 |
| April | 32,000 |
| May | 38,000 |
| June | 35,000 |
Steps
- Open the sales dataset in Tableau.
- Open a new worksheet.
- Select Order Date and Sales from the Data Pane.
- Open the Show Me panel.
- Select Line Chart if the selected fields support it.
- Review the date level used on the horizontal axis.
- Choose Month if monthly analysis is required.
- Use the Marks Card to customize the line and its appearance.
- Add Sales to Tooltip or Label when required.
- Rename the worksheet to Monthly Sales Trend.
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
- Create a bar chart using Show Me.
- Drag Region to Color.
- Drag Sales to Label.
- Use the Marks Card to adjust the bar appearance.
- Drag Order Date to Filters if a date-based restriction is required.
- Format Sales as currency if the measure represents monetary values.
- 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. |
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
- Select Category and Sales.
- Open Show Me.
- Create a Bar Chart.
- Sort the categories by sales.
- Display values on the bars.
Task 2: Monthly Sales Trend
- Select Order Date and Sales.
- Choose a Line Chart.
- Set the date level to Month.
- Review the sales trend.
- Add a meaningful worksheet title.
Task 3: Sales and Profit Relationship
- Select Sales and Profit.
- Choose a Scatter Plot if available.
- Add a suitable dimension to Detail if individual records are required.
- Use Color to distinguish Region.
- Review the relationship between the two measures.
Task 4: Regional Sales Highlight Table
- Select Region, Category and Sales.
- Choose Highlight Table if available.
- Review the color scale.
- Check the displayed values.
- 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.