Bar and column charts in Power BI - Dashboard Guide

Dashboard Mode - Bar and column charts

Dashboard Goal

Understand sales performance by product category and region using bar and column charts.

Sample Data

Product Category	Region	Sales
Electronics	North	1200
Electronics	South	900
Furniture	North	700
Furniture	South	600
Clothing	North	400
Clothing	South	500

Dashboard Components

• KPI Card: Total Sales
  Formula: Total Sales = SUM(SalesData[Sales])
  Result: 4300
• Bar Chart: Sales by Product Category
  X-axis: Product Category
  Y-axis: Sum of Sales
  Formula: SUM(SalesData[Sales]) grouped by Product Category
  Shows total sales for Electronics (2100), Furniture (1300), Clothing (900)
• Column Chart: Sales by Region
  X-axis: Region
  Y-axis: Sum of Sales
  Formula: SUM(SalesData[Sales]) grouped by Region
  Shows total sales for North (2300), South (2000)

Dashboard Layout

+----------------------+----------------------+
|      KPI Card        |                      |
|   Total Sales: 4300  |  Bar Chart: Sales by  |
|                      |  Product Category     |
+----------------------+                      |
|                      |                      |
|                      |                      |
+----------------------+----------------------+
|          Column Chart: Sales by Region       |
+----------------------------------------------+

Interactivity

A slicer for Region allows filtering all components. Selecting a region updates the KPI card, bar chart, and column chart to show sales only for that region.

Similarly, a slicer for Product Category filters all visuals to show sales for the selected category.

Self Check

If you add a filter to select Region = North, which components update and what are their new values?

• KPI Card: Total Sales updates to 2300
• Bar Chart: Sales by Product Category updates to Electronics (1200), Furniture (700), Clothing (400)
• Column Chart: Sales by Region updates to North (2300) only

Key Result

Dashboard showing total sales with bar chart by product category and column chart by region, all filterable by region and category.