Home Course home Curriculum Learner dashboard Skill tree Business projects Datasets Final project
🖥️ Module 1 · Power BI Desktop Beginner LESSON 06 / 72

First Look at Power BI Desktop

24 min 5 quiz questions 1 practical challenge 4 syllabus topics

Power BI Desktop puts a great deal on screen at once, and the standard reaction is to learn three buttons and ignore the rest. This lesson gives you the whole map instead — every region of the window, what it is for, and when you would go there. Ten minutes now saves a lot of hunting later.

Lesson 6 of 72 · Power BI Desktop 8%
01

Learning Objective

You cannot use a tool efficiently if you do not know where things are. This lesson is orientation: after it, no part of the Desktop window should be a mystery.

By the end of this lesson you will be able to
  • Name every major region of the Power BI Desktop window and its purpose
  • Switch between the three views and say what each one is for
  • Read the ribbon's structure, including contextual tabs
  • Show, hide and rearrange panes to suit the task you are doing
  • Find any command quickly, including via the search box
02

Why This Matters

Two practical reasons this matters more than it sounds.

First, tutorials will not match your screen. Power BI Desktop updates monthly and the ribbon moves. If you have learned "the third button along", you are stuck the moment it becomes the fourth. If you have learned "formatting lives in the Format pane, reached by the paintbrush icon", you are fine forever.

Second, the views are not interchangeable. A large share of "I can't find how to do X" questions come down to being in the wrong view. Relationships are invisible from Report view. Row-level data is invisible from Model view. Knowing which view owns which job eliminates that whole category of frustration.

The single most useful orientation fact
Report view builds visuals. Data view inspects rows. Model view manages relationships. If you cannot find something, ask which of those three jobs it belongs to, and switch views accordingly. That one sentence resolves most navigation confusion.
03

Concept

The window, region by region

Power BI Desktop's layout is stable even as individual buttons move. There are six regions worth naming.

The six regions
RegionWhereWhat it is for
RibbonAcross the topEvery command, grouped into tabs. Contextual tabs appear when you select certain objects.
View switcherLeft edge, three iconsSwitch between Report, Table (Data) and Model views.
Canvas / workspaceCentreChanges with the view: the report page, the data grid, or the model diagram.
Visualizations paneRight, first pane (Report view only)Visual gallery, field wells, formatting and analytics.
Data paneRight, last paneEvery table, column and measure in your model. Your model's public interface.
Filters paneRight, between the two (Report view only)Filters at visual, page and report level.

The three views in detail

The ribbon

Seven permanent tabs, plus contextual ones. You do not need to memorise them — you need to know roughly what lives where.

Ribbon tabs
TabWhat lives there
FileSave, Open, Import, Export, and — importantly — Options and settings
HomeGet data, Transform data, Refresh, new visual, new measure, Publish. The tab you use most.
InsertVisuals, text boxes, shapes, images, buttons, and Power Platform embeds
ModelingNew measure, new column, new table, manage relationships, manage roles (RLS), parameters
ViewThemes, page view scaling, gridlines, snap to grid, mobile layout, and the pane toggles
OptimizePerformance Analyzer, optimisation presets, pause visuals
HelpDocumentation, community, examples, and About — which tells you your version

Contextual tabs

Some tabs only appear when relevant. This is by design and it is worth expecting:

  • Select a visual → a Format tab appears with alignment and layering tools.
  • Select a measure in the Data pane → a Measure tools tab appears with the formula bar, format string and home table.
  • Select a column → a Column tools tab appears with data type, format, summarization, sort-by and data category.
  • Select a table → a Table tools tab appears.
If a command has vanished, you have deselected something
The commonest cause of "the button was there a minute ago" is that the contextual tab disappeared because you clicked elsewhere. Reselect the object and the tab returns.

Panes are movable and collapsible

The right-hand panes can be collapsed with the chevron at their top corner, and re-shown from the View ribbon tab. On a small screen this matters — collapsing the Filters pane while you build visuals reclaims useful canvas width.

Recent Desktop versions let you undock and rearrange panes, and the exact behaviour has changed across releases. If your panes look different from a tutorial, that is normal. View › Reset panes (or restarting Desktop) returns the default layout if you get into a mess.
04

Visual Explanation

The full Desktop window with every region marked. Select any numbered region to see what it does.

About this illustration
This is a labelled diagram of the interface drawn for teaching, not a screenshot. Power BI Desktop updates monthly and any screenshot ages within weeks. The regions and their purposes have been stable for years, which is why learning them by role rather than by pixel position is the durable approach. For current screenshots, Microsoft's own Power BI Desktop documentation is kept up to date.
05

Power BI Demonstration

A guided tour. Open Power BI Desktop with the report you built in Module 0 Lesson 5 — or any .pbix — and follow along.

Cycle through the three views
Click each of the three icons in the left rail in turn. Notice how the right-hand panes change: Report view has three panes, Table view has one, Model view has one plus a properties panel when something is selected.
Find your Desktop version
Help › About. Note the version and build number. When a tutorial does not match your screen, this is the first thing to check.
Open the Options dialog
File › Options and settings › Options. Note the two columns: Global settings apply to every file you open; Current File settings apply only to this .pbix. This distinction catches people out constantly.
Look at Current File › Data Load
This is where Auto date/time lives — the setting Module 0 recommended turning off. Confirm its state.
Try the ribbon search
Click the search box on the ribbon (or press Alt then start typing). Search for "manage relationships". It finds the command wherever it currently lives.
Select a visual and watch the ribbon change
In Report view, click any visual. A Format tab appears. Click empty canvas and it disappears. This is the contextual tab behaviour.
Select a column and open Column tools
Switch to Table view, click any column header. The Column tools tab appears with data type, format, summarization and sort-by. This is where the fixes from Module 0 Lesson 4 live.
Collapse and restore the Filters pane
Click the chevron at the top of the Filters pane to collapse it. Restore it from View › Filters. Practise this — on a laptop screen, reclaiming that width while building visuals is genuinely useful.
Explore the Analytics tab
Select a line chart, then click the magnifying-glass icon in the Visualizations pane. This is where average lines, constant lines, trend lines and forecasting live — not in Format, which is where most people look first.
FileOptions and settingsOptionsCurrent FileData Load
Global versus Current File is a real trap
Settings changed under Current File travel with that .pbix and nowhere else. Turning off Auto date/time in one file does not turn it off in the next one you create. If you want it off everywhere, there is a corresponding Global › Data Load setting — change both.
06

Example Dataset

This lesson is conceptual and needs no download — it uses the sample data shown inline above. The next lesson that requires a file will link it here.

You can still browse every dataset in the course from the dataset library.

07

Step-by-Step Exercise

A find-it drill. For each task, name the view and the pane or ribbon tab you would use — then actually go and do it in Desktop to confirm.

  1. Change the number of decimal places shown on a revenue column
  2. Create a relationship between two tables
  3. Add a trend line to a line chart
  4. Check how many rows loaded into a table
  5. Rename a report page
  6. Turn off Auto date/time for the current file
  7. Find out which Desktop version you are running
  8. Hide a column so report authors cannot see it
  9. Apply a report-wide colour theme
  10. See which filters are currently applied to a specific visual
Do the drill properly
Guess first, then check. The guessing is what builds the mental model — looking it up straight away teaches you much less. Getting one wrong and finding out why is worth more than getting nine right by looking.
08

Expected Result

Where each command lives
TaskViewWhere
Change decimal places on a columnTable viewSelect column → Column tools › Format
Create a relationshipModel viewDrag between key columns, or Modeling › Manage relationships
Add a trend lineReport viewSelect the chart → Visualizations pane → Analytics (magnifying glass)
Check row countTable viewSelect the table → read the status bar at the bottom
Rename a report pageReport viewDouble-click the page tab, or right-click → Rename page
Turn off Auto date/timeAnyFile › Options and settings › Options › Current File › Data Load
Find your versionAnyHelp › About
Hide a column from report viewModel or Table viewRight-click the field → Hide in report view
Apply a colour themeReport viewView › Themes
See a visual's filtersReport viewSelect the visual → read Filters on this visual in the Filters pane
The pattern in that table
Notice how consistently the answer follows from the three-view rule. Anything about a column's properties is Table view. Anything about relationships is Model view. Anything about appearance or filtering is Report view. Application-wide settings are under File. There are very few exceptions.
09

Common Mistakes

Looking for relationships in Report view
The Data pane shows tables, so it feels like relationships should be manageable from there. They are not — Report view has no concept of the relationship diagram.

Fix: Switch to Model view. Or use Modeling › Manage relationships, which opens the dialog from any view.
Hunting in Format for things that live in Analytics
Reference lines, average lines, min/max lines, trend lines and forecasting are all in the Analytics tab of the Visualizations pane, not the Format tab. People search Format exhaustively and conclude the feature does not exist.

Fix: Three icons at the top of the Visualizations pane: Build, Format (paintbrush), Analytics (magnifying glass). Check all three before concluding something is missing.
Changing a Current File setting and expecting it to persist
Turning off Auto date/time, then creating a new file next week and finding it back on.

Fix: Current File settings live in the .pbix. For behaviour you want everywhere, change the corresponding Global setting too.
Judging a layout in 'Fit to page' view
Fit to page scales the canvas to your window, which makes everything look comfortably spaced on a large monitor. The reader may be on a laptop.

Fix: Check in View › Page view › Actual size before you consider a layout finished. Module 8 covers canvas sizing properly.
Assuming a missing ribbon button means a missing feature
Contextual tabs disappear when you deselect. Preview features are off by default. Tenant policy can hide things.

Fix: Check three things: is the right object selected; is the feature in preview (Options › Preview features); and are you on a current version (Help › About).
10

Professional Tip

Learn the ribbon search box, not the ribbon
Press Alt and start typing, or click the search box on the ribbon. Type what you want in plain language — "manage roles", "conditional formatting", "performance analyzer" — and it takes you straight there.

This matters more in Power BI than in most software, because the ribbon genuinely does move between monthly releases. Search is version-proof; memorised button positions are not. Experienced users lean on it heavily.

Three keyboard shortcuts genuinely worth knowing:

ShortcutDoes
Ctrl + SSave. There is no autosave for local files — build the reflex
Ctrl + ZUndo. Works across most actions, but not across a Close & Apply
Ctrl + C / Ctrl + V on a visualDuplicates a visual with all its formatting — far faster than reformatting from scratch, and it works across pages and across files

That last one is the biggest time-saver in the list. Format one visual carefully, then copy it and swap the fields, rather than formatting each new visual from the default.

11

Knowledge Check

Knowledge Check

5 questions. Answer each one to see why the right answer is right.

You want to add an average line to a bar chart. Where do you find it?

Which view do you use to check how many rows actually loaded into a table?

You turn off Auto date/time in one file. Next week you create a new report and it is on again. Why?

A colleague says the Format ribbon tab has disappeared. What is the most likely cause?

What is the most durable way to learn where commands are, given that Desktop updates monthly?

12

Practical Challenge

Practical Challenge

Build your own interface reference card

Produce a one-page reference card for Power BI Desktop that you could hand to someone on their first day. It should let them find anything without hunting. Constrain it to one page — that constraint is the exercise, because it forces you to decide what actually matters.

Requirements
  • A three-view decision rule — one line telling the reader which view owns which job
  • A table of at least eight common tasks with the view and location for each
  • The contextual tab behaviour explained in one or two sentences
  • The Global vs Current File distinction explained in one sentence
  • Three keyboard shortcuts worth learning on day one
  • One line on what to do when a tutorial does not match your screen

The hard part is deciding what to leave out. A reference card that lists eighty commands is a manual, and nobody reads a manual on their first day.

Test each item against: would a beginner waste more than two minutes hunting for this? If not, cut it. Things like "where is Save" fail that test; things like "where is Manage relationships" pass it easily.

13

Solution

Try the challenge properly before opening this. Reading a solution you have not attempted feels like learning, but it is not.

A model reference card

The decision rule — put this at the top
Report view builds and formats visuals. Table view inspects rows and sets column properties. Model view manages relationships and organises the model. If you cannot find something, decide which of those three jobs it belongs to and switch views.

Where things live

I want to…ViewWhere exactly
Create or edit a relationshipModelDrag between key columns, or Modeling › Manage relationships
Change a column's data type or formatTableSelect the column → Column tools
Stop a numeric column from summingTableColumn tools › Summarization › Don't summarize
Check the row count after a loadTableSelect the table → read the status bar
Write a measureAnyHome › New measure, or right-click a table in the Data pane
Format a measure's display (currency, decimals)AnySelect the measure → Measure tools › Format
Add a trend or average lineReportVisualizations pane → Analytics tab (magnifying glass)
Change colours and fonts on a visualReportVisualizations pane → Format tab (paintbrush)
See what is filtering a visualReportFilters pane → "Filters on this visual"
Apply a colour theme to the whole reportReportView › Themes
Hide a field from report authorsModel or TableRight-click the field → Hide in report view
Find out why a page is slowReportOptimize › Performance Analyzer
Set up Row-Level Security rolesAnyModeling › Manage roles
Change Auto date/timeAnyFile › Options and settings › Options › Data Load

Three things that confuse everyone

  • Contextual tabs. Format, Measure tools, Column tools and Table tools only appear while the matching object is selected. If a tab has vanished, you have clicked empty space — reselect the object.
  • Global vs Current File. In the Options dialog, Global settings apply to every file you open; Current File settings are stored inside this specific .pbix and travel with it.
  • Build / Format / Analytics. The Visualizations pane has three modes, switched by three small icons. Most "that feature doesn't exist" moments are someone looking in only one of them.

Day-one shortcuts

ShortcutWhy it earns its place
Ctrl + SThere is no autosave for local .pbix files
Ctrl + C / Ctrl + V on a visualCopies all formatting with it — across pages and across files. The single biggest time-saver in report building
Alt then typeOpens ribbon search. Finds any command by plain-language name, regardless of which release moved it where
The line about mismatched tutorials
"Power BI Desktop updates monthly, so tutorials go out of date fast. If your screen does not match, check Help › About for your version, check Options › Preview features in case the feature is not enabled yet, and use ribbon search rather than following 'third button along' instructions."
What makes this card good rather than merely complete
It leads with a rule that generalises, not a list that does not. Someone who internalises the three-view rule can find the fifty commands the card does not list. A card that only lists commands teaches nothing transferable — and that is the difference between reference material and training material.
14

Lesson Summary

Key takeaways
  • The window has six regions: ribbon, view switcher, canvas, Visualizations pane, Filters pane and Data pane.
  • Report view builds visuals · Table view inspects rows and sets column properties · Model view manages relationships. This rule resolves most navigation confusion.
  • The Visualizations pane has three modes — Build, Format (paintbrush), Analytics (magnifying glass). Reference and trend lines live in Analytics.
  • Contextual ribbon tabs appear only while the matching object is selected.
  • In Options, Global applies everywhere; Current File is stored in the .pbix.
  • Learn roles, not button positions — Desktop updates monthly and the ribbon moves. Use ribbon search.
  • Copy-paste a formatted visual rather than reformatting a new one. It is the biggest single time-saver in report building.

Syllabus topics delivered

First look at Power BI DesktopRibbon anatomyThe three viewsWhat does this button do?
15

Progress

Marking a lesson complete stores your progress in this browser and updates your BitWithBite learner dashboard. Nothing is uploaded anywhere.

Lesson complete — 8% of Power BI Mastery done
Progress saved. Keep the momentum: the next lesson builds directly on this one.