Choosing the wrong chart type is one of the most common ways to make correct data tell the wrong story. This lesson covers the principles behind picking the right visual, walks through every core chart type in Power BI, and explains how to format visuals consistently so your reports look intentional rather than assembled by accident.
The One Rule of Chart Selection
Every chart type answers a specific kind of question. Before you pick a visual, ask yourself what question this chart is answering. The answer determines the chart type. Using the wrong chart for the question does not just look bad — it actively misleads the viewer by implying a relationship in the data that does not exist.
The question you are answering
Use this chart type
Do NOT use
How do categories compare to each other?
Bar / Column chart
Pie chart (hard to compare slices)
How does a value change over time?
Line chart
Bar chart (implies discrete, not continuous)
What share does each category contribute?
Donut / Pie chart (max 5 slices)
Line chart (implies time progression)
What is a single headline number?
Card / KPI visual
Bar chart with one bar
Is there a relationship between two numeric values?
Scatter chart
Line chart (implies time)
How do sub-categories contribute to a total?
Stacked bar / Stacked column
Multiple pie charts
Where does performance sit vs a target?
KPI visual / Gauge
Plain card (shows no target)
The Core Visual Types — One by One
Power BI ships with over 30 visual types. Most professional reports use fewer than ten. These are the ones you need to know thoroughly — every other visual is a variation on these foundations.
Bar / Column Chart
Compare categories
Electronics
Furniture
Accessories
Field wellsX Axis: category · Y Axis: measure · Legend: optional split
Use whenComparing discrete categories where order matters or is alphabetical
TipUse a horizontal bar chart (not column) when category names are long — they fit better on the Y axis without truncation
Watch outAvoid more than 8–10 bars — viewers cannot compare 20 bars. Filter to top N instead.
Line Chart
Show change over time
Field wellsX Axis: date/time field · Y Axis: numeric measure · Secondary Y Axis: optional second measure
Use whenShowing trends, growth rates, or any continuous change over a time dimension
TipUse an Area chart (line chart filled underneath) when you want to emphasise the volume, not just the trend direction
Watch outNever use a line chart for non-time data (e.g. Revenue by Region) — it implies a continuous relationship between the categories
Card & Multi-row Card
Single headline numbers
REVENUE
$83K
ORDERS
1,204
Field wellsFields: one aggregated value per card. Change aggregation (Sum, Count, Average) by clicking the field dropdown in the well.
Use whenDisplaying KPIs at the top of a page — revenue, order count, average order value, customer count
TipCards respond to slicers and cross-filters — when a viewer clicks a region, the card automatically updates to show that region's total
Watch outA card with no aggregation shows the first row value — always check the aggregation setting. The label under the number tells you what it is summing.
Table & Matrix
Detailed row data / cross-tab
Customer
Orders
Revenue
Alice
7
$3,850
Bob
4
$1,200
Field wellsTable: Columns well — drag any fields. Matrix: Rows, Columns, Values — creates a pivot-style cross-tab view.
Use whenViewers need to read exact numbers — a table shows data that charts would obscure. Use a Matrix when you need row and column totals simultaneously (e.g. Revenue by Region × Month).
TipEnable conditional formatting on numeric columns — colour scale or data bars — to give tables the visual weight of a chart while preserving exact numbers
Watch outTables with hundreds of rows frustrate viewers — add a Top N filter or move large tables to a dedicated detail page behind a drill-through action
Slicer
Interactive filter control
REGION
Field wellsField: one field that viewers will filter by. Style options: List, Dropdown, Between (date range), Relative date.
Use whenGiving viewers control over which data they see — Region, Year, Product Category, Status. Always visible on the canvas unlike Filters pane filters.
TipFor date slicers, use the "Between" style (date range picker) rather than a list — it is far more intuitive for viewers. Format → Slicer Settings → Style → Between.
Watch outSlicers only filter the page they are on unless you configure Sync Slicers (covered in Lesson 13). Multi-select is enabled by default — hold Ctrl to select multiple values.
KPI Visual
Actual vs target vs trend
REVENUE
$83,450
▲ 12.4% vs target
Field wellsValue: actual metric · Target: goal / budget figure · Trend axis: date field for the mini sparkline
Use whenShowing whether a metric is on-track or off-track vs a target. The colour (green/red) instantly communicates direction without the viewer doing any mental arithmetic.
TipYou need a separate Target measure in your model — usually a DAX measure that returns a fixed budget number or a % of last year's revenue
Watch outThe KPI visual only shows one metric at a time. If you need multiple KPIs in a row, use multiple separate KPI visuals or use Card visuals with conditional formatting instead.
Formatting Visuals — The Format Pane
Every visual has a Format pane — the paintbrush icon in the Visualizations panel. Click any visual, then click the paintbrush icon to open it. The Format pane is divided into two tabs: Visual (settings specific to this chart type) and General (settings common to every visual — title, background, border, shadow, alt text).
Format pane — bar chart selected
Visual
General
Y-axis▼
Font size: 10
Display units: Auto
Value decimal places: 0
X-axis▶
Data labels▶
Legend▶
Columns▶
Zoom slider▶
Key formatting settings to know:
General tab → Title
Every visual should have a clear, descriptive title. Turn it on, set font to 12–14px bold, and write the title as a complete description: "Revenue by Product Category (2024)" not just "Revenue".
Visual tab → Data labels
Turning on data labels shows the exact value on each bar or data point. For bar charts, set display units to "K" (thousands) or "M" (millions) and decimal places to 0 for clean readability.
Visual tab → Columns → Colours
Use a single consistent colour for most charts. Use colour variation only when each colour conveys meaning — for example, different colours per category in a legend, or red/green for positive/negative values.
General tab → Background + Border
Set a subtle background (very light grey or white) and a thin border for visual grouping. Consistent background and border across all visuals on a page creates a grid-like professional appearance.
Applying Format Consistently — The Format Painter
Once you have formatted one visual exactly how you want it — title style, data labels, background, colours — you can copy that formatting to any other visual in one click using the Format Painter. This is the fastest way to ensure consistent formatting across an entire page without manually repeating every setting.
Using the Format Painter:
1. Click the source visual (the one with the formatting you want to copy)
2. In the Home ribbon, click the Format Painter icon (paint roller icon)
The cursor changes to a paint roller
3. Click any other visual on the canvas
All formatting from the source visual is instantly applied
To apply to multiple visuals without re-clicking Format Painter:
Double-click the Format Painter icon (step 2) to lock it on
Then click each destination visual one by one
Press Escape when done
What IS copied:
Title font, size, colour · Background colour · Border settings
Data label settings · Axis font sizes · Legend position
What is NOT copied:
Field assignments · Visual type · Data itself
Specific colour mappings tied to data values
Before and after Format Painter on three bar charts
Before — inconsistent formatting
Revenue by Category
orders by region
QUANTITY BY PRODUCT
After — Format Painter applied from first chart
Revenue by Category
Orders by Region
Quantity by Product
Conditional Formatting
Conditional formatting applies colour, icons, or data bars to cells in a table or matrix automatically based on the value. It turns a flat table into a heatmap that lets viewers instantly spot high and low performers without reading every number.
Table with conditional formatting — Revenue column
Region
Orders
Revenue
Revenue (data bar)
North
412
$38,200
South
287
$24,100
East
198
$13,450
West
89
$7,700
Left column: background colour scale (green = high, red = low) · Right column: data bars proportional to value
To apply conditional formatting: select the table or matrix → click the field dropdown arrow next to the measure in the Values well → Conditional formatting → choose Background colour, Font colour, Data bars, or Icons.
Teacher's Note: The most common formatting mistake beginners make is treating the Format pane like a toy — adding shadows, 3D effects, gradients, and eight different colours because they can. Professional reports use restraint: one or two brand colours, consistent typography at two sizes (title and body), minimal borders, and no decorative elements that do not carry information. The goal of formatting is to reduce visual noise so the data speaks louder — not to make the chart look busy.
Practice
Practice 1 of 3
You want to show how Revenue has changed month by month over a full year. The correct chart type to use is a ___ chart, because it shows continuous change over time.
Practice 2 of 3
To copy the title style, background colour, and data label settings from one visual to another without manually re-entering every setting, you use the ___ Painter in the Home ribbon.
Practice 3 of 3
The KPI visual requires three field wells — Value (the actual metric), Target (the goal), and Trend ___ (a date field that draws the mini sparkline showing recent history).
Lesson Quiz
Quiz 1 of 3
A colleague builds a line chart showing Revenue by Region (North, South, East, West). The chart has four points connected by a line. Why is this the wrong chart type for this data?
Quiz 2 of 3
You have a table visual showing Revenue by Region. You want to make the highest revenue cells green and the lowest red without adding any extra columns. What is the correct approach?
Quiz 3 of 3
You format a bar chart with a specific title font, background colour, and data label style. You now need to apply the same formatting to seven other bar charts on the page. What is the most efficient method?
Next up — Lesson 15 covers Basic Charts in depth — building and fine-tuning the clustered bar, clustered column, line, area, and combo charts with real datasets, sorting, Top N filtering, and secondary axes.
