Visuals: Bar, Line & Pie Charts
Pick the right chart and Power BI draws it for you — just drag fields into the wells.
What you will learn
- Create a chart by dropping fields
- Choose bar, line or pie for the right job
- Read what each chart is telling you
How you make any chart
Charts in Power BI are called visuals. Making one is the same three steps every time:
- On the Report view, click a chart icon in the Visualizations pane (bar, line, pie, etc.).
- An empty chart appears on the canvas.
- Drag fields from the Data pane into the chart’s wells (the boxes labelled Axis, Values, Legend).
A worked bar chart
Let us show total sales for each region. Click the Clustered bar chart icon, then:
- Drag Region into the Axis well (this makes one bar per region).
- Drag the Total Sales measure into the Values well (this sets the bar length).
Region (Axis) + Total Sales (Values)
North ██████████████████ 10100
South █ 450
East ██ 1200Note: Output: Three bars appear — North is by far the longest at 10100, then East at 1200, then South at 450. In one glance you can see North is your strongest region, which is much faster than reading the numbers in a table.
A worked line chart (a trend over time)
A bar chart compares categories, but to see whether sales are going up or down you want a line chart. Click the Line chart icon, then drag Month (the Date field, grouped by month) into the Axis well and Total Sales into the Values well. Imagine the monthly totals come out like this:
Month (Axis) + Total Sales (Values)
Jan ● 4,000
Feb ● 5,200
Mar ● 6,800 (rising trend)
Apr ● 7,500
line climbs left -> rightNote: Output: A single line climbs from 4,000 in January up to 7,500 in April. Because the line rises steadily left to right, you instantly read the story: sales are growing month over month. A bar chart could show the same four numbers, but the line makes the upward trend jump out — that is what line charts are for.
A worked pie chart (parts of a whole)
When you want each category’s share of the total, use a pie chart. Click the Pie chart icon, drag Product into the Legend well and Total Sales into the Values well. With our four rows (Keyboard 1200 + 1200, Mouse 450, Monitor 8900) the slices come out as:
Product (Legend) + Total Sales (Values)
Monitor 8900 -> biggest slice (about 76%)
Keyboard 2400 -> middle slice (about 20%)
Mouse 450 -> tiny slice (about 4%)
Total 11,750 = the whole pieNote: Output: The pie is dominated by one large Monitor slice (about 76% of 11,750), with a smaller Keyboard slice (about 20%) and a thin Mouse sliver (about 4%). The whole circle is the grand total of 11,750, and each slice is one product’s share of it — so you see at a glance that Monitor brings in most of the money.
Choosing the right chart
Each chart type answers a different kind of question. Pick the one that matches yours:
| Chart | Best for | Example question |
|---|---|---|
| Bar / Column | Comparing categories | Which region sells most? |
| Line | A trend over time | Are sales rising each month? |
| Pie / Donut | Parts of a whole | What share is each product? |
A quick way to choose: are you comparing separate things (bar), watching something change over time (line), or splitting one total into shares (pie)? Naming the question first picks the chart for you.
Tip: Click a visual, then click a different chart icon to instantly change its type — the fields stay put. Try your data as a bar, then a line, and see which tells the story best.
Watch out: Pie charts only work well with a few categories. With more than about five slices they become hard to read — a bar chart is almost always clearer.
Q. Which chart is best for showing a trend over time, like monthly sales?
✍️ Practice
- Make a bar chart of Total Sales by Product.
- Change that same visual into a pie chart and decide which is easier to read.
🏠 Homework
- Build a line chart of Total Sales by Month (or Date) and write one sentence describing the trend you see.