Tutorials › Power BI › Bar and Column Charts

Bar and Column Charts

Build and format bar and column charts — the most-used visuals in business dashboards

Bar and column charts are the workhorses of business reporting. They are the clearest way to compare values across categories. In Power BI, a "bar chart" has horizontal bars; a "column chart" has vertical bars. Use horizontal bars when category names are long — they are easier to read. Use column charts for time-based comparison.

Example

Build and configure a bar chart
BASIC BAR CHART:
  Visualisations pane → Bar chart (horizontal bars icon)
  Y-axis field well: drag Category column
  X-axis field well: drag Sales measure
  → Bars automatically sorted descending by value

GROUPED BAR CHART (compare within categories):
  Y-axis: Region
  X-axis: Sales
  Legend: Year
  → Shows each year's bars side-by-side per region

STACKED BAR CHART (show composition):
  Select "Stacked bar chart" icon
  Y-axis: Region
  X-axis: Sales
  Legend: Category
  → Each bar shows category breakdown within region

100% STACKED (show share, not absolute):
  Select "100% stacked bar chart"
  → Bars all same length, shows % breakdown

SORTING:
  Click the "..." menu on the visual
  Sort by → choose column → Ascending or Descending
  Default: sorted by value descending (most useful)

DATA LABELS:
  Format pane → Data labels → toggle On
  Set position: Inside end, Outside end, Inside center

Key Points

  • ✓Bar chart = horizontal (good for long labels). Column chart = vertical (good for time)
  • ✓Sort bar charts by value — unsorted bars are harder to compare
  • ✓Limit categories to 10–12 — too many bars become unreadable
  • ✓Use data labels when exact values matter; remove them when only relative size matters
  • ✓Conditional formatting on bars: Format pane → Data bars or Rules

Practice Question

You have 15 product category names and want to compare their sales. Which chart orientation is most readable?