Power BI- Retail Sales Performance Dashboard

 🛒 Retail Sales Performance Dashboard (Example Template):

📊 Layout Overview:

Section	Visual	Purpose
Top Row	KPI Cards (Total Sales, Total Orders, Profit Margin, Customer Count)	Quick at-a-glance metrics
Second Row	Line Chart (Sales Over Time)	Trend analysis month-by-month
Third Row Left	Stacked Bar Chart (Sales by Product Category)	See which categories are driving revenue
Third Row Middle	Map Visual (Sales by Region)	Geographic insights
Third Row Right	Pie/Donut Chart (Sales by Payment Method)	Distribution of payment types
Bottom Row	Table/Matrix (Detailed Order List)	Drill down to specific orders

 

Filters (Slicers) on the Side:

·       Date Range (calendar slicer)

·       Region (dropdown)

·       Product Category (dropdown)

·       Customer Segment (dropdown)

 

 Interactivity Features:

• Clicking a region on the map filters all visuals to show that region's data.

• Clicking a product category in the bar chart filters the table below.

• Hovering over a point in the line chart shows a tooltip with extra metrics like "Returns" or "New Customers".

• Drillthrough: Right-click on a product to jump to a Product Details Page.

---

🎨 Best Practices for a Clean Dashboard:

• Use consistent colors (e.g., blue for sales, green for profit, red for loss).

• Limit visuals per page (ideally 5–7) to avoid clutter.

• Use icons and clear labels (no jargon).

• Make the most important KPI BIG and TOP-CENTER.

• Always test slicer syncing if you have multiple pages.

Let’s start by making a simple layout sketch you can follow when building your interactive Power BI dashboard.

Here’s the rough structure:

 ------------------------------------------------------
|   📈 Total Sales   |   📊 Total Orders   |  💰 Profit Margin   |
 ------------------------------------------------------
|                                                      |
|             📉 Line Chart (Sales Over Time)          |
|                                                      |
 ------------------------------------------------------
|  📊 Bar Chart      | 🗺️ Map Visual        | 🍩 Pie Chart         |
| (Sales by Category) | (Sales by Region)  | (Payment Methods)    |
 ------------------------------------------------------
|                                                      |
|                  🧾 Table (Order Details)             |
 ------------------------------------------------------
| 📅 Date Filter | 📍 Region Filter | 🛍️ Product Filter |
 ------------------------------------------------------

🧠 How to read this:

• Top row = Important KPIs (big cards)

• Second row = Sales trend over time

• Third row = 3 main visuals side by side

• Bottom = Table and slicers (filters)

---

Now, here’s a super simple step-by-step to build this in Power BI Desktop:

1. Load your data → Connect Excel / SQL / CSV etc.

2. Create 4 KPI cards:

   • Total Sales = SUM(Sales Amount)

   • Total Orders = COUNT(Order ID)

   • Profit Margin = Calculation

   • Total Customers = DISTINCTCOUNT(Customer ID)

3. Add Line Chart:

   • Axis: Date

   • Value: Sales

4. Add Stacked Bar Chart:

   • Axis: Product Category

   • Value: Sales

5. Add Map Visual:

   • Location: Region

   • Value: Sales

6. Add Pie Chart:

   • Legend: Payment Method

   • Values: Sales

7. Add Table/Matrix:

   • Columns: Order ID, Customer Name, Product, Sales, Profit

8. Add Slicers:

   • Drag and drop Date, Region, Product Category into slicers.

Set up interactions:
→ Go to Format → Edit Interactions to control how clicking on visuals affects the others.