First Look at Power BI Desktop
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.
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.
- 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
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.
Concept
The window, region by region
Power BI Desktop's layout is stable even as individual buttons move. There are six regions worth naming.
| Region | Where | What it is for |
|---|---|---|
| Ribbon | Across the top | Every command, grouped into tabs. Contextual tabs appear when you select certain objects. |
| View switcher | Left edge, three icons | Switch between Report, Table (Data) and Model views. |
| Canvas / workspace | Centre | Changes with the view: the report page, the data grid, or the model diagram. |
| Visualizations pane | Right, first pane (Report view only) | Visual gallery, field wells, formatting and analytics. |
| Data pane | Right, last pane | Every table, column and measure in your model. Your model's public interface. |
| Filters pane | Right, 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.
| Tab | What lives there |
|---|---|
| File | Save, Open, Import, Export, and — importantly — Options and settings |
| Home | Get data, Transform data, Refresh, new visual, new measure, Publish. The tab you use most. |
| Insert | Visuals, text boxes, shapes, images, buttons, and Power Platform embeds |
| Modeling | New measure, new column, new table, manage relationships, manage roles (RLS), parameters |
| View | Themes, page view scaling, gridlines, snap to grid, mobile layout, and the pane toggles |
| Optimize | Performance Analyzer, optimisation presets, pause visuals |
| Help | Documentation, 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.
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.
Visual Explanation
The full Desktop window with every region marked. Select any numbered region to see what it does.
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.
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.
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.
- Change the number of decimal places shown on a revenue column
- Create a relationship between two tables
- Add a trend line to a line chart
- Check how many rows loaded into a table
- Rename a report page
- Turn off Auto date/time for the current file
- Find out which Desktop version you are running
- Hide a column so report authors cannot see it
- Apply a report-wide colour theme
- See which filters are currently applied to a specific visual
Expected Result
| Task | View | Where |
|---|---|---|
| Change decimal places on a column | Table view | Select column → Column tools › Format |
| Create a relationship | Model view | Drag between key columns, or Modeling › Manage relationships |
| Add a trend line | Report view | Select the chart → Visualizations pane → Analytics (magnifying glass) |
| Check row count | Table view | Select the table → read the status bar at the bottom |
| Rename a report page | Report view | Double-click the page tab, or right-click → Rename page |
| Turn off Auto date/time | Any | File › Options and settings › Options › Current File › Data Load |
| Find your version | Any | Help › About |
| Hide a column from report view | Model or Table view | Right-click the field → Hide in report view |
| Apply a colour theme | Report view | View › Themes |
| See a visual's filters | Report view | Select the visual → read Filters on this visual in the Filters pane |
Common Mistakes
Fix: Switch to Model view. Or use Modeling › Manage relationships, which opens the dialog from any view.
Fix: Three icons at the top of the Visualizations pane: Build, Format (paintbrush), Analytics (magnifying glass). Check all three before concluding something is missing.
Fix: Current File settings live in the .pbix. For behaviour you want everywhere, change the corresponding Global setting too.
Fix: Check in View › Page view › Actual size before you consider a layout finished. Module 8 covers canvas sizing properly.
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).
Professional Tip
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:
| Shortcut | Does |
|---|---|
Ctrl + S | Save. There is no autosave for local files — build the reflex |
Ctrl + Z | Undo. Works across most actions, but not across a Close & Apply |
Ctrl + C / Ctrl + V on a visual | Duplicates 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.
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?
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.
- 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.
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
Where things live
| I want to… | View | Where exactly |
|---|---|---|
| Create or edit a relationship | Model | Drag between key columns, or Modeling › Manage relationships |
| Change a column's data type or format | Table | Select the column → Column tools |
| Stop a numeric column from summing | Table | Column tools › Summarization › Don't summarize |
| Check the row count after a load | Table | Select the table → read the status bar |
| Write a measure | Any | Home › New measure, or right-click a table in the Data pane |
| Format a measure's display (currency, decimals) | Any | Select the measure → Measure tools › Format |
| Add a trend or average line | Report | Visualizations pane → Analytics tab (magnifying glass) |
| Change colours and fonts on a visual | Report | Visualizations pane → Format tab (paintbrush) |
| See what is filtering a visual | Report | Filters pane → "Filters on this visual" |
| Apply a colour theme to the whole report | Report | View › Themes |
| Hide a field from report authors | Model or Table | Right-click the field → Hide in report view |
| Find out why a page is slow | Report | Optimize › Performance Analyzer |
| Set up Row-Level Security roles | Any | Modeling › Manage roles |
| Change Auto date/time | Any | File › 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
| Shortcut | Why it earns its place |
|---|---|
Ctrl + S | There is no autosave for local .pbix files |
Ctrl + C / Ctrl + V on a visual | Copies all formatting with it — across pages and across files. The single biggest time-saver in report building |
| Alt then type | Opens ribbon search. Finds any command by plain-language name, regardless of which release moved it where |
Lesson Summary
- 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
Progress
Marking a lesson complete stores your progress in this browser and updates your BitWithBite learner dashboard. Nothing is uploaded anywhere.