Why choosing the right visual matters in Power BI - Dashboard Impact

Dashboard Mode - Why choosing the right visual matters

Business Question

How can choosing the right visual help us understand sales data better and make smarter decisions?

Sample Data

Region	Product	Sales	Profit	Month
North	Widget	100	30	Jan
South	Widget	150	50	Jan
East	Gadget	200	70	Jan
West	Gadget	130	40	Jan
North	Widget	120	35	Feb
South	Gadget	180	60	Feb
East	Widget	160	55	Feb
West	Gadget	140	45	Feb

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(SalesData[Sales])
  Result: 1180
• KPI Card: Total Profit
  Formula: Total Profit = SUM(SalesData[Profit])
  Result: 385
• Bar Chart: Sales by Region
  Shows total sales for each region to compare performance visually.
• Pie Chart: Sales by Product
  Shows sales proportion by product to understand product contribution.
• Line Chart: Sales Over Months
  Shows sales trend over Jan and Feb to see growth or decline.
• Table: Detailed Sales Data
  Shows all rows for detailed inspection.

Dashboard Layout

+----------------------+----------------------+
| Total Sales (KPI)    | Total Profit (KPI)   |
+----------------------+----------------------+
|                      Bar Chart: Sales by Region           |
+----------------------------------------------------------+
| Pie Chart: Sales by Product | Line Chart: Sales Over Months |
+-----------------------------+-----------------------------+
|                   Detailed Sales Data Table               |
+----------------------------------------------------------+

Interactivity

Filters for Region, Product, and Month let users select specific data slices. When a filter is applied, all visuals update to show only the filtered data. For example, selecting Region = 'North' updates KPI cards, charts, and table to show only North region sales and profit.

Self Check

If you add a filter for Product = Widget, which components update?

• Both KPI cards update to show total sales and profit for Widget only.
• Bar chart updates to show sales by region for Widget.
• Pie chart updates but will show only Widget sales (100% slice).
• Line chart updates to show sales trend over months for Widget.
• Table shows only rows where Product is Widget.

Key Result

A dashboard showing how choosing the right visual (KPI cards, bar, pie, line charts, and table) helps understand sales and profit data by region, product, and month.