7  Creating Basic Visualizations

NoteFrom Data Model to Visual

With a clean data model in place, you are ready to build the part of Power BI that report consumers actually see: the visualizations. A visualization in Power BI is any chart, table, card, or graphic that represents data from your model. Every visual is interactive by default, responding to slicers, filters, and clicks on other visuals on the same report page.

This chapter walks through the report canvas, the process of building visuals, and each of the core visualization types available in Power BI Desktop.

7.1 Setting Up the Canvas

7.1.1 The Report Canvas

NoteUnderstanding the Report Canvas

The report canvas is the blank page area where you design your report. It is visible when you are in the Report view, accessed by clicking the report icon at the top of the left navigation bar. Each Power BI file can contain multiple report pages, shown as tabs at the bottom of the canvas. Each page is an independent layout where you place, size, and arrange visuals.

The canvas works much like a slide in a presentation tool. You drag, drop, resize, and reposition visuals freely across the surface. Power BI does not enforce a grid layout, giving you full control over the placement and proportion of every element.

[Insert screenshot of the Power BI Desktop Report view showing the blank canvas, the Visualizations pane on the right, the Data pane on the far right, and the page tabs at the bottom]

Adding a Visual to the Canvas

NoteHow to Add a Visualization

There are two ways to place a visual on the canvas:

Method 1 — Click from the Visualizations pane:

  1. In the Visualizations pane on the right, click the icon of the visual type you want (bar chart, line chart, table, etc.)
  2. An empty placeholder visual appears on the canvas
  3. With the visual selected, drag fields from the Data pane into the field wells in the Visualizations pane (such as Axis, Values, or Legend) to populate it with data

Method 2 — Drag a field first:

  1. From the Data pane, drag a numeric field directly onto the blank canvas
  2. Power BI automatically creates a default visual (usually a column chart) using that field
  3. Add more fields or switch the visual type using the Visualizations pane

[Insert screenshot of the Visualizations pane showing the visual type icons grid, with one visual type highlighted, and the field wells (Axis, Values, Legend) below the icons]

Resizing and Repositioning Visuals

NoteWorking with Visuals on the Canvas

Once a visual is placed on the canvas:

  • Move it by clicking and dragging the visual body to a new position
  • Resize it by clicking the visual to select it and then dragging any of the eight handles that appear on its border (corners and midpoints)
  • Copy it by pressing Ctrl+C and Ctrl+V, or by right-clicking and selecting Copy then Paste
  • Delete it by selecting it and pressing the Delete key

To select multiple visuals at once, hold Ctrl and click each one. With multiple visuals selected, you can align them, distribute them evenly, or group them using the Format ribbon.

[Insert screenshot of a selected visual on the canvas showing the resize handles on the borders and corners, with the Format ribbon visible at the top]

TipUse the Format Ribbon to Align Visuals Precisely

For a professional report layout, use the alignment tools in the Format ribbon (visible when one or more visuals are selected). Options include Align Left, Align Top, Distribute Horizontally, and Distribute Vertically. Consistent alignment across visuals makes a report significantly easier to read and signals a high level of care to report consumers.

The Visualizations Pane and Field Wells

NoteUnderstanding Field Wells

Each visual type in Power BI has a specific set of field wells, shown in the Visualizations pane when a visual is selected. Field wells define what role each data field plays in the visual. Common field wells include:

  • Axis (or Category) — the dimension used to group data along the chart axis
  • Values — the numeric measure being plotted or aggregated
  • Legend — a second dimension used to colour-code or segment the data
  • Tooltips — additional fields shown when a user hovers over a data point
  • Small multiples — a field used to split one chart into a grid of smaller charts

Drag fields from the Data pane into the appropriate well to build the visual. Drag a field out of a well to remove it. Click the dropdown arrow next to any field in a well to change its aggregation (Sum, Average, Count, etc.) or to apply conditional formatting.

[Insert screenshot of the Visualizations pane with a bar chart selected, showing the Axis, Legend, Values, and Tooltips field wells populated with field names]

7.2 Trend and Comparison Charts

7.2.1 Bar and Column Charts

NoteWhen to Use Bar and Column Charts

Bar charts and column charts display the same type of information but orient it differently. A column chart places categories along the horizontal axis and values on the vertical axis, making bars run upward. A bar chart flips this, placing categories on the vertical axis and extending bars horizontally to the right.

Both are ideal for comparing values across discrete categories, such as sales by product, revenue by region, or order counts by month. Column charts are the more common default for time-based comparisons, while bar charts are preferred when category labels are long and would overlap if placed horizontally.

Both chart types are also available in clustered (multiple series placed side by side) and stacked (multiple series stacked on top of each other) variants.

flowchart LR
    A[Column Chart] --> B[Clustered Column\nCategories side by side]
    A --> C[Stacked Column\nCategories stacked]
    A --> D[100% Stacked Column\nProportional stacking]
    E[Bar Chart] --> F[Clustered Bar]
    E --> G[Stacked Bar]
    E --> H[100% Stacked Bar]
    classDef default fill:#2a4d69,color:#ffffff,stroke:#ffcc00,stroke-width:3px,rx:10px,ry:10px;

NoteHow to Build a Column Chart
  1. In the Visualizations pane, click the Clustered column chart icon
  2. Drag a category dimension (such as ProductCategory) from the Data pane into the X-axis field well
  3. Drag a numeric measure (such as Total Sales) into the Y-axis field well
  4. Optionally, drag a second dimension into the Legend field well to create a clustered or colour-coded chart

[Insert screenshot of a clustered column chart on the canvas with the field wells showing X-axis, Y-axis, and Legend populated, and the chart displaying coloured bars grouped by category]

TipWhen to Use Stacked vs. Clustered

Use a clustered chart when you want to compare individual segment values directly side by side. Use a stacked chart when the total of the segments matters as much as the individual parts. Use a 100% stacked chart when you want to show the proportional share of each segment within a total, and the absolute values are less important than the relative breakdown.

7.2.2 Line Chart

NoteWhen to Use a Line Chart

A line chart connects data points with a continuous line, making it the best choice for visualizing trends over time. The continuous line emphasizes the direction and rate of change between data points, which discrete bar charts cannot convey as naturally. Use line charts for time series data such as monthly revenue, daily website visits, weekly stock levels, or any metric tracked at regular intervals over a period.

Power BI also offers a Line and clustered column chart that combines both types on the same canvas, useful for showing a volume measure (bars) alongside a rate or percentage measure (line) in the same visual.

NoteHow to Build a Line Chart
  1. In the Visualizations pane, click the Line chart icon
  2. Drag a date or time field (such as OrderDate or Month) into the X-axis field well
  3. Drag a numeric measure (such as Total Revenue) into the Y-axis field well
  4. Optionally, drag a dimension into the Legend field well to show multiple lines, one per category

[Insert screenshot of a line chart showing monthly revenue over a year, with the X-axis showing months and the Y-axis showing revenue values, and a smooth upward trend line visible]

TipUse Your Date Table Hierarchy for Drill-Down

When you place a field from your Date dimension table on the X-axis of a line chart, Power BI automatically creates a date hierarchy (Year, Quarter, Month, Day). Clicking the drill-down arrows in the chart header lets you zoom from a yearly view down to a monthly or daily view without creating separate visuals. This is one of the most effective interactive features in Power BI for time series analysis.

7.2.3 Area Chart

NoteWhen to Use an Area Chart

An area chart is a line chart with the region below the line filled with colour. The filled area emphasizes the magnitude of values over time and makes it easier to compare the volume between multiple series. Use area charts when the cumulative size of a value matters, not just its trend. For example, showing total revenue accumulation across quarters, or comparing the market share of two product lines over time.

Power BI offers both a standard Area chart and a Stacked area chart, which stacks multiple series to show how individual parts contribute to a total over time.

NoteHow to Build an Area Chart
  1. Click the Area chart icon in the Visualizations pane
  2. Drag a date or time field into the X-axis field well
  3. Drag a numeric measure into the Y-axis field well
  4. Drag a category dimension into the Legend field well to create multiple filled areas, one per category

[Insert screenshot of a stacked area chart showing revenue by product category over months, with coloured filled regions for each category stacked on top of each other]

7.3 Part-to-Whole and Summary Charts

7.3.1 Pie and Donut Charts

NoteWhen to Use Pie and Donut Charts

Pie charts and donut charts display the proportional share of each category within a whole. The full circle represents 100% of the total, and each slice represents one category’s contribution to that total. A donut chart is identical to a pie chart but has an empty centre, which can display a summary value such as the grand total.

These charts work well when you have a small number of categories (ideally five or fewer) and the relative proportions between them are the primary insight. Avoid pie and donut charts when categories have similar values, as the human eye struggles to compare slice sizes accurately in those cases.

NoteHow to Build a Pie or Donut Chart
  1. Click the Pie chart or Donut chart icon in the Visualizations pane
  2. Drag a category dimension (such as Region or ProductCategory) into the Legend field well
  3. Drag a numeric measure (such as Total Sales) into the Values field well
  4. Power BI automatically calculates each slice as a percentage of the total

[Insert screenshot of a donut chart showing sales by region, with coloured slices labelled with region names and percentage values, and the grand total displayed in the centre of the donut]

WarningLimit Pie Charts to Five Categories or Fewer

Pie and donut charts become unreadable as the number of slices increases. With more than five or six categories, slices become too thin to compare meaningfully, and labels begin to overlap. For datasets with many categories, a bar chart sorted by value communicates proportional differences far more clearly.

7.3.2 Card and Multi-Row Card

NoteWhen to Use Cards

A Card visual displays a single summary value in large, prominent text. It is the simplest visual in Power BI and one of the most widely used, because it communicates a key metric instantly without requiring any interpretation. Total Revenue, Total Orders, Average Customer Rating, and Units Sold are all examples of values that belong on a Card.

A Multi-row Card displays multiple summary values together in a stacked layout, one label-and-value pair per row. It is useful for showing a set of related KPIs in a compact space without the full structure of a table.

NoteHow to Build a Card Visual
  1. Click the Card icon in the Visualizations pane
  2. Drag a numeric measure (such as Total Revenue) into the Fields field well
  3. Power BI displays the aggregated value in large text at the centre of the visual

For a Multi-row Card, click its icon and drag multiple fields into the Fields well. Each field appears as a separate row showing its label and value.

[Insert screenshot of a Card visual showing “Total Revenue: ₹ 48,50,000” in large bold text, alongside a Multi-row Card showing three metrics stacked vertically with their labels and values]

TipPlace Cards at the Top of Your Report Page

Cards are most effective when positioned prominently at the top or top-left of a report page, acting as summary anchors. A reader scanning the report for the first time immediately sees the headline numbers before exploring the detailed charts below. This layout pattern, known as the “inverted pyramid”, is standard practice in professional Power BI report design.

7.3.3 KPI Visual

NoteWhen to Use a KPI Visual

The KPI visual is designed specifically for performance tracking against a defined target. It displays three pieces of information together: the current value of a metric, a target value to compare against, and a trend axis (usually a time series) showing how the metric has moved over time. The visual uses colour coding (typically green for on or above target, red for below) to communicate performance status instantly.

KPI visuals are ideal for executive dashboards and operational scorecards where stakeholders need to see at a glance whether key metrics are meeting expectations.

NoteHow to Build a KPI Visual
  1. Click the KPI icon in the Visualizations pane
  2. Drag the metric measure (such as Monthly Revenue) into the Value field well. This is the current performance value
  3. Drag the target measure (such as Revenue Target) into the Target field well. This is what the metric is being compared against
  4. Drag a time field (such as Month or Date) into the Trend axis field well. This populates the small trend sparkline shown beneath the main value

Power BI automatically calculates the variance between Value and Target and applies the appropriate colour coding.

[Insert screenshot of a KPI visual showing “Monthly Revenue: ₹ 12,40,000” as the main value, “Target: ₹ 11,00,000” below it, a green upward indicator showing the target is exceeded, and a small sparkline trend at the bottom showing revenue over the past twelve months]

TipCombine KPI Visuals with Cards for a Strong Summary Panel

A common and effective dashboard pattern is to place a row of KPI visuals across the top of a report page, one for each critical metric (Revenue vs. Target, Orders vs. Target, Customer Satisfaction vs. Benchmark). Below this summary row, place detailed charts that allow the reader to explore the breakdown behind each headline figure. This structure lets executives read the top-line status in seconds while analysts drill deeper into the supporting data.

7.4 Detail and Analytical Charts

7.4.1 Table and Matrix

NoteWhen to Use Tables and Matrices

A Table visual displays data in rows and columns, similar to a spreadsheet. Every row represents a record, and every column represents a field or measure. Tables are appropriate when report consumers need to read individual values precisely, look up specific records, or export data for further use.

A Matrix visual is a pivot table equivalent in Power BI. It allows you to place dimensions on both the rows and the columns, creating a grid of aggregated values at each intersection. Matrices also support drill-down through row and column hierarchies, making them powerful for multi-level analysis such as sales by year and quarter broken down by region and country.

NoteHow to Build a Table Visual
  1. Click the Table icon in the Visualizations pane
  2. Drag any fields or measures from the Data pane into the Columns field well
  3. Power BI displays each field as a column and each row of data as a table row

[Insert screenshot of a Table visual showing columns for CustomerName, Region, OrderDate, ProductName, and Revenue, with multiple rows of data visible]

NoteHow to Build a Matrix Visual
  1. Click the Matrix icon in the Visualizations pane
  2. Drag a dimension (such as Year, then Quarter) into the Rows field well to create a row hierarchy
  3. Drag another dimension (such as Region) into the Columns field well
  4. Drag a numeric measure (such as Total Sales) into the Values field well
  5. Power BI fills each cell with the aggregated value for that row/column combination

[Insert screenshot of a Matrix visual showing Years and Quarters as expandable row headers, Regions as column headers, and Total Sales values at each intersection, with row and column subtotals visible]

TipTables Show Detail Rows, Matrices Show Aggregations

Use a Table when you need to display individual records or when consumers need to read specific row-level values. Use a Matrix when you need to show aggregated values across two dimensions simultaneously, with the ability to expand or collapse levels of a hierarchy. For most executive or summary dashboards, the Matrix is the more appropriate choice.

7.4.2 Scatter Chart

NoteWhen to Use a Scatter Chart

A scatter chart (also called a scatter plot) plots individual data points on a two-dimensional grid defined by two numeric axes, one on the X-axis and one on the Y-axis. Each point represents one entity, such as a product, a customer, or a region. The position of the point reveals the relationship between the two measures for that entity.

Scatter charts are ideal for exploring correlations and distributions, for example, whether products with higher prices also have higher return rates, or whether customers who spend more also place orders more frequently. Adding a third numeric field to the Size well creates a bubble chart, where each point’s size represents a third measure.

NoteHow to Build a Scatter Chart
  1. Click the Scatter chart icon in the Visualizations pane
  2. Drag a dimension (such as ProductName or CustomerID) into the Values field well — this defines what each dot represents
  3. Drag a numeric measure into the X-axis field well (for example, Average Price)
  4. Drag a second numeric measure into the Y-axis field well (for example, Total Returns)
  5. Optionally, drag a third numeric measure into Size to create a bubble chart, and drag a dimension into Legend to colour-code the dots by category

[Insert screenshot of a scatter chart with each point representing a product, X-axis showing Average Price, Y-axis showing Return Rate, and bubble size representing Total Revenue, with points colour-coded by product category]

TipUse the Play Axis for Animated Time Series

The Scatter chart has a unique Play axis field well that accepts a time field (such as Year or Month). When you click the Play button on the visual, the chart animates through time, showing how the relationship between your two measures evolves across each period. This is an effective way to present dynamic data in a live presentation or a video recording of a report.

7.4.3 Treemap

NoteWhen to Use a Treemap

A treemap displays hierarchical data as a set of nested rectangles. Each rectangle represents one category, and its size is proportional to the value it represents. Colour is used to indicate a second dimension or to reinforce the size grouping. Treemaps are effective for showing part-to-whole relationships across a hierarchy, such as the revenue contribution of each product within each product category, where both the category level and the individual product level are visible simultaneously.

NoteHow to Build a Treemap
  1. Click the Treemap icon in the Visualizations pane
  2. Drag a category dimension (such as ProductCategory) into the Category field well. This defines the top-level grouping
  3. Drag a sub-category dimension (such as ProductName) into the Details field well. This creates the nested rectangles within each group
  4. Drag a numeric measure (such as Total Revenue) into the Values field well. This determines the size of each rectangle

[Insert screenshot of a Treemap visual showing product categories as large rectangles subdivided into smaller rectangles for individual products, with rectangle sizes proportional to revenue and colours varying by category]

WarningTreemaps Become Hard to Read with Many Small Categories

When a dataset contains many categories with small values, their corresponding rectangles become too small to display labels and are effectively invisible. For datasets with more than fifteen to twenty categories, consider a sorted bar chart, which communicates the same ranking information with less visual noise.

7.4.4 Funnel Chart

NoteWhen to Use a Funnel Chart

A funnel chart displays a process that moves through sequential stages, with the value decreasing (or occasionally increasing) at each stage. The resulting shape, wider at the top and narrower at the bottom, resembles a funnel. Funnel charts are most commonly used for conversion and pipeline analysis, such as a sales pipeline moving from Leads to Qualified Prospects to Proposals to Closed Deals, or a website user journey from Visits to Product Views to Add-to-Cart to Purchases.

Each stage shows both the absolute value and the percentage remaining relative to the first stage, making it easy to spot where the most significant drop-off occurs.

NoteHow to Build a Funnel Chart
  1. Click the Funnel icon in the Visualizations pane
  2. Drag the stage dimension (such as PipelineStage or ConversionStep) into the Category field well
  3. Drag a numeric measure (such as OpportunityCount or UserCount) into the Values field well
  4. Power BI automatically orders stages by value, from largest to smallest, forming the funnel shape

[Insert screenshot of a funnel chart showing a sales pipeline with stages labelled Lead, Qualified, Proposal, Negotiation, and Closed, with decreasing bar widths at each stage and percentage labels showing drop-off rates]

TipSort Stages Manually When Order Matters

By default, Power BI sorts funnel stages from largest to smallest value. For process funnels where the sequence of stages is fixed (a lead must become a prospect before becoming a customer), the automatic sort will produce the correct order naturally if the values decrease as expected. However, if your data contains stages that are not strictly decreasing, use a sort column (a numeric rank field) in your dimension table to enforce the correct stage order.

7.5 Choosing the Right Visual

7.5.1 Choosing the Right Visual

NoteA Practical Guide to Visual Selection

Choosing the right visualization type is as important as having the right data. The wrong chart type can obscure the insight rather than reveal it. Use the guide below as a starting point for selecting the most appropriate visual for each analytical question your report needs to answer.

Analytical Question Recommended Visual
How does a metric change over time? Line chart, Area chart
How do categories compare to each other? Bar chart, Column chart
What is each category’s share of the total? Pie chart, Donut chart, Treemap
What is the headline number for one metric? Card
Am I above or below target? KPI visual
How do two numeric measures relate to each other? Scatter chart, Bubble chart
What are the individual records in my data? Table
How do values break down across two dimensions? Matrix
Where does the biggest drop-off in a process occur? Funnel chart
How does volume accumulate and compare over time? Area chart, Stacked area chart
ImportantLet the Question Drive the Visual, Not the Other Way Around

The most effective Power BI reports start with a clear analytical question and then select the visual that answers it most directly. A common mistake is to start with a visual type and then look for data to fill it. Always begin with the question your audience is asking, choose the visual that answers it clearly, and apply only the formatting needed to make the answer obvious at a glance.

Summary

Concept Description
Chart Types
Bar and Column Charts Comparing categories across a single measure
Line and Area Charts Showing trend or change over time
Pie and Donut Charts Showing parts of a whole, used sparingly
Tables and Matrices Detail grids and pivot-style summarisation
Cards and KPIs Single-number visuals that highlight the headline metric
Maps Bubble, filled, and ArcGIS maps for geographic data
Interactivity and Choice
Slicers User-facing filter controls for slicing the report
Choosing the Right Visual Matching encoding to the analytical question being answered