Menu
×
   ❮   
HTML CSS JAVASCRIPT SQL PYTHON JAVA PHP C C++ C# AWS W3.CSS HOW TO BOOTSTRAP REACT MYSQL JQUERY EXCEL XML DJANGO NUMPY PANDAS NODEJS DSA TYPESCRIPT ANGULAR ANGULARJS GIT POSTGRESQL MONGODB ASP AI R GO KOTLIN SWIFT SASS VUE GEN AI SCIPY CYBERSECURITY DATA SCIENCE INTRO TO PROGRAMMING HTML & CSS BASH RUST TOOLS MATH

Power BI Visuals


Share

What Is a Visual?

A visual is one chart, table, card or slicer on a report page.

Visuals are also called visualizations.

In the First Report chapter you built a card, a column chart, a slicer and a line chart from one flat table.

Now your model is much richer.

It has the Sales, Products, Stores and Date tables, the hierarchies, and the DAX measures from the previous chapters.

In this chapter you use that model to build every common type of visual.

Open the Power BI file you worked in during the DAX chapter, for example poke_mart_dax.pbix.

It holds the Poke Mart model from DAX Introduction, the hierarchies from Hierarchies (Year Hierarchy in Date, Category Hierarchy in Products and Region Hierarchy in Stores), and these measures, all stored in the Sales table:

If you start here, build the model and these measures first.

Each page of this chapter names the measures it uses.

In this chapter, as in the DAX Measures chapter, measures are formatted as Whole number with a thousands separator.

The percentage measures (Margin %, % of All Regions and Sales YoY %) are formatted as Percentage with 2 decimals, and Avg Order Value as Decimal number with 2 decimals.

The tables of expected values use the same formats.

Charts may shorten large numbers on their axes, for example to 3M.

Point to a column, bar or point to see its exact value in a tooltip.


The Visualizations Pane

You build and change visuals in the Visualizations pane, to the right of the canvas.

The pane has three parts.

Switch between them with the icons at the top of the pane:

PartWhat you do there
Build visualChoose a visual type from the gallery, and put fields in the field wells.
Format visualChange how the selected visual looks. It has two tabs: Visual, with settings for this type of visual, such as axes, colors and data labels, and General, with settings that almost every visual has, such as size, title and background.
AnalyticsAdd reference lines, such as an average line, a constant line or a trend line. Only some visuals support them.

The Visualizations pane on the Build visual tab for a clustered column chart, with callouts on the Build visual, Format visual and Analytics icons, the visual gallery, and the field wells X-axis and Y-axis holding Region and Total Sales

The pane always shows the settings of the selected visual:

  • If no visual is selected, selecting a visual type in the gallery adds a new, empty visual to the canvas.
  • If a visual is selected, selecting a visual type changes that visual to the new type.

The gallery holds the built-in visuals.

You can add more visuals from Microsoft AppSource with Get more visuals, but this tutorial uses only the built-in ones.

This is the Format visual part, with its two tabs:

The Format visual part of the Visualizations pane for a clustered column chart, showing the Visual and General tabs, with the Visual tab open and its cards such as X-axis, Y-axis, Columns and Data labels

You will format visuals in detail in the Format Visuals chapter.


The Field Wells

Below the gallery, the Build visual part shows the field wells.

A field well is a box that decides what a field does in the visual.

Each visual type has its own wells:

VisualMain wells
Clustered column chartX-axis (categories), Y-axis (values), Legend
Clustered bar chartY-axis (categories), X-axis (values), Legend
Line chartX-axis, Y-axis, Secondary y-axis, Legend
Pie chartLegend, Values
TableColumns
MatrixRows, Columns, Values

Most charts also have a Tooltips well, for extra values that appear when you point to a data point, and a Small multiples well, which splits the chart into one small chart per value.

There are three ways to put a field in a well:

  • Select the check box next to the field in the Data pane. Power BI picks the well.
  • Drag the field from the Data pane to a well.
  • Drag the field onto the visual on the canvas.

To remove a field from a well, select the X next to it.

As a rule, a measure such as Total Sales goes in a value well (Y-axis, Values).

A column that you group by, such as Region, goes in a category well (X-axis, Legend, Rows).



Example: Same Fields, Three Visuals

Let's see what the wells do.

Tip: add a new report page for each chapter (select + next to the page tabs), so the visuals do not crowd each other.

  1. Click an empty spot on the canvas, so no visual is selected.
  2. In the Visualizations pane, select Clustered column chart. If the pane shows the settings of the page instead of the gallery, select the Build visual icon first.
  3. In the Data pane, expand Stores and select Region. Then expand Sales and select Total Sales.

Power BI puts Region in the X-axis well and Total Sales in the Y-axis well.

You get one column per region:

RegionTotal Sales
Hoenn2,972,000
Johto3,363,650
Kanto3,081,150

Now change the type of the same visual:

  1. With the chart selected, select Clustered bar chart. The columns turn into horizontal bars. Look at the wells: Region is now in the Y-axis well and Total Sales in the X-axis well, because a bar chart has its categories on the vertical axis.
  2. Select Table. Both fields move to the Columns well, and the visual shows the numbers themselves, with a Total row at the bottom.

The table shows exactly the same numbers as the charts, plus the total:

RegionTotal Sales
Hoenn2,972,000
Johto3,363,650
Kanto3,081,150
Total9,416,800

The data did not change.

Only the way it is drawn changed.

Choosing a visual means choosing how your readers see the numbers.


Choosing a Visual

Start with the question the visual should answer.

Then pick the visual from this table:

I want to show...VisualChapter
One important number, such as total salesCardCard and KPI
A number compared with a targetKPICard and KPI
Exact values, with several measures side by sideTableTable and Matrix
Values across rows and columns, with subtotalsMatrixTable and Matrix
A comparison of a few categories, such as sales by regionClustered column or bar chartBar and Column Charts
A comparison of many categories, or categories with long namesClustered bar chartBar and Column Charts
The parts that make up each category's totalStacked column or bar chartBar and Column Charts
A trend over time, such as sales by monthLine chartLine and Area Charts
A trend over time, and how big the total isArea or stacked area chartLine and Area Charts
Two measures with very different scales, such as sales and marginLine and clustered column chartLine and Area Charts
The share of a whole, with only a few partsPie or donut chartPie and Donut Charts
The share of a whole, with many partsTreemapPie and Donut Charts
The relationship between two measuresScatter chartScatter Charts
A filter that readers can use on the pageSlicerSlicers

When in doubt, start with a bar or column chart.

Bars are easy to compare, because they all start from the same baseline.

Use a table when readers need to look up exact values, and a chart when they need to see a pattern.

Note: Power BI also has map visuals, such as Azure Maps, Map and Filled map.

They place values on a real map, based on place names or coordinates.

This tutorial does not cover maps: the Poke Mart stores are in fictional Pokemon cities, so a map visual could not place them correctly.

To compare stores, use a bar chart instead.


In This Chapter

The next pages build each type of visual from the Poke Mart model:



Free account

Track your progress

XP earned 0 Day streak 0 Spaces 0 League —

New

Learn in Adventure Mode W3Schools Adventure App

Coding fundamentals as bite-sized lessons and challenges.

×

Contact Sales

If you want to use W3Schools services as an educational institution, team or enterprise, send us an e-mail:
sales@w3schools.com

Report Error

If you want to report an error, or if you want to make a suggestion, send us an e-mail:
help@w3schools.com

W3Schools is optimized for learning and training. Examples might be simplified to improve reading and learning. Tutorials, references, and examples are constantly reviewed to avoid errors, but we cannot warrant full correctness of all content. While using W3Schools, you agree to have read and accepted our terms of use, cookies and privacy policy.

Copyright 1999-2026 by Refsnes Data. All Rights Reserved. W3Schools is Powered by W3.CSS.