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 Interface


Share

The Power BI Desktop Window

This is Power BI Desktop with the Poke Mart data loaded and one chart on the page:

The Power BI Desktop window with numbered callouts: 1 ribbon, 2 view buttons, 3 report canvas, 4 page tabs, 5 Filters pane, 6 Visualizations pane, 7 Data pane

The window has these main parts:

  1. Ribbon: tabs with buttons for getting data, adding visuals, modeling and more.
  2. View buttons: icons on the left side that switch between the views of your file.
  3. Report canvas: the large area in the middle where you place visuals.
  4. Page tabs: one tab for each page of the report, at the bottom.
  5. Filters pane: filters for the selected visual, the current page, or all pages.
  6. Visualizations pane: choose a visual type, and set which fields it uses and how it looks.
  7. Data pane: the tables and fields (columns) in your data.

Do not try to learn every button now.

You will use each part in the chapters to come.


The Views

The icons on the left side of the window switch between five views.

Each view shows a different side of the same file:

ViewWhat you do there
Report viewBuild report pages with visuals. Power BI Desktop opens in this view.
Table viewSee the rows and columns of the data you loaded.
Model viewSee all tables and the relationships between them.
DAX query viewWrite DAX queries that return data from the model.
TMDL ViewEdit the model as code, for advanced users.

As a beginner, you will mostly use Report view, Table view and Model view.

Table view was called Data view in older versions of Power BI Desktop.

You may still see that name in older guides.


The Ribbon

The ribbon works like the ribbon in Excel.

Each tab groups related commands:

TabWhat you find there
HomeGet data, Transform data, Refresh and Publish
InsertNew pages, visuals, text boxes and buttons
ModelingNew measures and columns, relationships, data types
DesignThe look of the report pages, such as themes
ViewButtons to show or hide panes, and how the page is shown
OptimizeTools to find out why a report is slow
HelpHelp links, and About, which shows your version number

This is the Home tab.

You will use Get data on the left in almost every project:

The Home tab of the Power BI Desktop ribbon with the Get data button highlighted

Some tabs appear only when you need them.

For example, when you select a visual, the Format and Data / Drill tabs appear, as in the first picture on this page.

When you select a column in the Data pane, a Column tools tab appears.

The ribbon also has a search box at the top.

Type what you want to do, for example "new page", to find the right button.



The Report Canvas and Pages

The report canvas is where you build your report.

You add visuals to it, then move and resize them like shapes in Excel.

A report can have many pages.

The page tabs at the bottom of the canvas show them:

  • Select a tab to open that page.
  • Select the + next to the tabs to add a new page.
  • Right-click a tab to rename, duplicate or hide the page.

A new report starts with one empty page, called Page 1.


The Panes

When you work in Report view, three panes sit to the right of the canvas: Filters, Visualizations and Data.

The Filters, Visualizations and Data panes in Power BI Desktop, with a clustered column chart selected: Category is in the X-axis well and Sum of Sales in the Y-axis well

Data Pane

The Data pane lists the tables in your data.

Expand a table to see its fields (columns).

Select the check box next to a field to add it to the selected visual, or drag the field onto the canvas.

Small icons show what kind of field it is:

  • A sigma sign (Σ) marks a number field that Power BI summarizes automatically, for example by adding it up.
  • A calendar icon marks a date field. It opens into a date hierarchy: Year, Quarter, Month and Day.
  • A calculator icon marks a measure, a calculation you write yourself with DAX.

Older versions and guides call this pane the Fields pane.

Visualizations Pane

The Visualizations pane has three parts.

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

  • Build visual: a gallery of visual types, such as column charts, line charts, pie charts, cards, tables, maps and slicers. Select one to add it to the canvas, or to change the type of the selected visual. Below the gallery are the field wells, the boxes that decide how each field is used. A column chart has wells such as X-axis, Y-axis and Legend. The wells change with the visual type.
  • Format visual (the brush icon): colors, titles, labels, fonts and other formatting.
  • Analytics (the magnifying glass icon): extra lines, such as an average line or a trend line.

Filters Pane

The Filters pane shows the filters for the selected visual, for the current page, and for all pages of the report.

Power BI adds every field you use in a visual to the Filters pane automatically.

You can also drag other fields into it.

Filters in the Filters pane are saved with the report.

Later you will also learn about slicers, which are filters placed right on the canvas.

Note: If the Filters pane is missing, open the View tab and select Filters under Show panes.

A pane that you collapsed with the double arrow at its top right shrinks to a narrow strip; select the strip to open the pane again.

If the Visualizations pane is gone and the build and format buttons appear on the visual itself, the preview feature On-object interaction is turned on.

This tutorial uses the default layout.

To turn the preview off, go to File > Options and settings > Options > Preview features, clear On-object interaction, and restart Power BI Desktop.


Power Query Editor

One important part of Power BI Desktop is not in the main window.

When you select Transform data on the Home tab, the Power Query Editor opens in its own window.

There you clean and shape data before it is loaded into the report.

You will learn Power Query in a later chapter.



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.