Basic Power BI Charts
Basic charts help users understand business data by converting numbers into visual representations. Power BI provides column charts, bar charts, line charts, and other visuals to compare values, identify trends, and communicate results clearly.
Learning Objectives
- Understand the purpose of basic Power BI charts.
- Identify the difference between bar, column, and line charts.
- Choose suitable fields for chart axes and values.
- Create and format a chart in Power BI Desktop.
- Interpret a chart and avoid common visualization mistakes.
1. What Is a Chart?
A chart is a visual representation of data. Instead of reading many rows in a table, users can compare categories, observe changes over time, and identify patterns through a visual.
Example: Monthly Sales
This example shows monthly sales increasing from January to April. A column chart makes the difference between monthly values easy to see.
2. Common Basic Charts
| Chart Type | Best Used For | Example |
|---|---|---|
| Clustered Column Chart | Comparing values across categories | Sales by month |
| Clustered Bar Chart | Comparing categories with horizontal bars | Sales by product |
| Line Chart | Showing trends over time | Monthly revenue trend |
| Stacked Column Chart | Comparing totals and their components | Sales by month and region |
| Area Chart | Showing trends with emphasis on magnitude | Revenue over time |
3. Clustered Column Chart
A clustered column chart displays vertical bars for categories. The height of each bar represents the value associated with that category.
Column Chart Structure
How to Create a Column Chart
- Open your report in Power BI Desktop.
- Select an empty area on the report canvas.
- Choose the Clustered Column Chart from the Visualizations pane.
- Drag a category field, such as Month or Product, to the X-axis.
- Drag a numeric field, such as Sales Amount, to the Y-axis or Values field well.
- Check the aggregation and confirm that the chart displays the expected result.
4. Clustered Bar Chart
A clustered bar chart displays horizontal bars. It is especially useful when category names are long or when you want to rank products, employees, or regions by a numeric value.
Sales by Product
When Should You Use a Bar Chart?
- When comparing many categories.
- When category names are long.
- When presenting a product or region ranking.
- When users need to compare the length of horizontal bars.
5. Line Chart
A line chart connects data points to show how a measure changes across an ordered sequence, such as dates or months. It is commonly used for revenue trends, customer growth, and performance monitoring.
Monthly Revenue Trend
The line rises from January to February, dips slightly in March, and rises again in April. This makes changes over time easy to identify.
6. Stacked Column Chart
A stacked column chart divides each column into segments. Each segment represents part of the total, allowing users to compare both overall values and the contribution of categories such as regions or departments.
Sales by Month and Region
A stacked chart is useful when you need to see the total and how its components contribute to that total. If the main goal is to compare individual segments precisely, a clustered chart may be easier to read.
7. Understand Chart Field Wells
The field wells available in Power BI depend on the selected visual and the current version of Power BI Desktop. Common roles include category, value, legend, and tooltips.
| Field Role | Purpose | Example |
|---|---|---|
| X-axis | Defines categories or horizontal positions | Month |
| Y-axis / Values | Defines the numeric measure being plotted | Sales Amount |
| Legend | Splits data into series or groups | Region |
| Tooltips | Displays additional details when hovering | Order Count |
How Data Becomes a Chart
8. Aggregation and Chart Accuracy
When a numeric column is added to a chart, Power BI may summarize it using Sum, Average, Minimum, Maximum, or another available aggregation. The correct choice depends on what the data represents.
- Sum: Adds values, such as total sales.
- Average: Calculates the arithmetic mean, such as average order value.
- Count: Counts non-empty values.
- Minimum: Finds the smallest value.
- Maximum: Finds the largest value.
9. Formatting a Basic Chart
Good formatting makes a chart easier to understand without distracting the reader. Select the chart and use the Format visual options available in your Power BI Desktop version.
- Add a clear and meaningful chart title.
- Use readable axis titles and category labels.
- Choose colors that make categories easy to distinguish.
- Display data labels when they improve readability.
- Use appropriate number formats, such as currency or whole numbers.
- Keep gridlines subtle and remove unnecessary visual elements.
10. Practice Activity
Scenario: Retail Sales Analysis
Use the following sample data to build three visuals.
| Month | Product | Region | Sales Amount |
|---|---|---|---|
| January | Laptop | North | 25,000 |
| January | Phone | South | 18,000 |
| February | Laptop | North | 30,000 |
| February | Phone | South | 22,000 |
| March | Laptop | North | 34,000 |
| March | Phone | South | 26,000 |
Tasks
- Create a column chart showing total sales by month.
- Create a bar chart comparing sales by product.
- Create a line chart showing the monthly sales trend.
- Add Region to the Legend field of a suitable chart.
- Format sales values consistently and give each visual a meaningful title.
11. Knowledge Check
Question 1: Which chart is generally suitable for showing a trend over time?
A. Line chart
B. Card
C. Table only
Question 2: Which chart is useful when category labels are long?
A. Clustered bar chart
B. Line chart only
C. Gauge only
Question 3: What should you verify when a numeric field is added to a chart?
A. The aggregation and data type
B. Only the background color
C. Only the report page name
Show Answers
- Question 1: A — Line chart.
- Question 2: A — Clustered bar chart.
- Question 3: A — The aggregation and data type.
Summary
- Column charts compare values across categories.
- Bar charts are useful for comparing categories with horizontal bars.
- Line charts show trends across an ordered sequence, such as time.
- Stacked charts show totals and the contributions of their components.
- Field wells determine how data is represented in a visual.
- Always verify aggregation, sorting, labels, and number formats.
- Clear formatting helps users interpret charts correctly.