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?

Related Topics

Power BI Visualisations OverviewEvery chart type in Power BI, what it is best for, and when to use whichConditional Formatting in Power BIApply colour scales, data bars, and icon sets to make key values stand outSlicers and Filters in Power BIAdd slicers and configure the filter pane to let users explore data interactively