Creating a Sales Dashboard: Step‑by‑Step Guide to Visualizing Total Sales by Region, Product, and Salesperson

Introduction

The transcript walks through building a simple sales dashboard that shows total sales broken down by region, product, and salesperson. It covers data placement, value‑field settings, number formatting, chart options, and visual tweaks such as shadows and outlines.

1. Prepare the Data Model

• Load the sales table that contains fields like Region, Product, Salesperson, Units Sold, and Sales Amount.
• Ensure each field is correctly typed (text for names, numeric for sales and units).

2. Add Value Fields to the Visual

• Drag Total Sales (or create a measure SUM(Sales Amount)) into the Values area.
• Repeat for Units Sold if you need a separate metric.
• Use the Rows or Columns shelves to place Region, Product, and Salesperson as needed.

3. Configure Number Formatting

• Click the Value Field Settings for each numeric field.
• Choose Number Format → Custom and copy the desired format (e.g., #,##0 for whole numbers or $#,##0.00 for currency).
• Apply the same format to all sales measures to keep the dashboard consistent.

4. Build the Core Visuals

• Total Sales by Region: Use a bar or column chart, set Region on the axis and Total Sales as the value.
• Total Sales by Product: Duplicate the chart, replace the axis field with Product.
• Total Sales by Salesperson: Create a third chart with Salesperson on the axis.
• For each chart, enable Data Labels and Leader Lines if you want the numbers to stand out.

5. Refine the Appearance

• Turn off unnecessary outlines and borders to achieve a clean look.
• Add subtle shadows to chart containers for depth.
• Use the Format Pane to adjust font size, colors, and background.
• If a chart shows items with no data, enable the Show items with no data option to keep the axis stable.

6. Interactivity and Refresh

• Enable Cross‑filtering so selecting a region automatically filters the product and salesperson charts.
• Use the Refresh button after any data source update to keep numbers current.
• Save the report and publish it to the dashboard workspace for team access.

7. Quick Tips

• Use Ctrl + C / Ctrl + V to duplicate visuals quickly.
• Double‑click a visual title to rename it (e.g., "Total Sales by Region").
• Keep the layout simple: one metric per visual, consistent colors, and clear titles.

Summary of Steps

1. Load and verify data.
2. Drag sales measures into the Values area.
3. Set custom number formats.
4. Create separate charts for region, product, and salesperson.
5. Adjust visual styling (shadows, outlines, labels).
6. Enable interactivity and refresh as needed.
7. Save and share the dashboard.

Common Issues & Fixes

• Missing data: Turn on "Show items with no data".
• Incorrect number format: Re‑open Value Field Settings and re‑apply the custom format.
• Visual clutter: Remove unnecessary borders and simplify color schemes.

By following these straightforward steps—loading the data, configuring value fields, applying consistent number formats, building three focused charts, and polishing the visual design—you can create a clear, interactive sales dashboard that instantly shows total sales by region, product, and salesperson without needing to watch the original tutorial again.