Power BI Interface¶
Before you build anything, you need to know where everything lives. Power BI Desktop has four distinct views, each with a specific purpose. Analysts who skip this orientation waste time hunting for features — spend 20 minutes here and you will save hours later.
Learning Objectives¶
- Navigate the four views without hesitation
- Identify the purpose of each pane (Fields, Visualizations, Filters)
- Understand the difference between a report page and a dashboard
- Orient yourself in a file someone else built
The Four Views¶
Access views from the left-side icon panel.
1. Report View¶
This is where you spend most of your time. The canvas is the blank area where you drag and drop visuals. Each tab at the bottom is a report page — think of it like a worksheet tab in Excel.
What you can do here: - Add, resize, and format visuals - Apply page-level and visual-level filters - Add slicers for user interaction - Set up drill-through pages
2. Data View¶
Shows the actual data in each table — similar to an Excel table view. Use this to: - Verify that your data loaded correctly - Check data types (text, number, date) - See what a calculated column produced row-by-row - Inspect how Power Query transformations affected the data
For mid-level analysts
The Data view is essential for debugging DAX calculated columns. If a column is returning unexpected values, Data view shows you the result for every row so you can trace the logic.
3. Model View¶
A visual map of all your tables and the relationships between them. This is where you: - Create and edit relationships (drag from one column to another) - View relationship cardinality (one-to-many, many-to-many) - Check which direction filters flow - Spot missing relationships before they cause incorrect totals
Many-to-many relationships
If Power BI detects a many-to-many relationship, it will warn you. These almost always indicate a data model problem — usually a missing bridge/junction table. Do not accept many-to-many relationships without understanding why they exist.
4. DAX Query View¶
Added in 2023. Lets you write and test DAX queries directly — similar to running a SQL SELECT against your model. Useful for: - Testing DAX expressions before embedding them in measures - Debugging complex time intelligence formulas - Exploring what the engine returns for a given filter context
For senior analysts
DAX Query View is also useful for documentation and handoff. You can write a query that returns the exact values a measure should produce, which makes QA and peer review much faster.
The Three Panes¶
The right side of the Report view has three collapsible panes.
Fields Pane¶
Lists all tables and their columns/measures. Key behaviors: - Columns with a sigma (Σ) icon are numeric and will be aggregated by default - Columns with a table icon are dimensions (text, date, category) - Measures you create appear with a calculator icon - You can drag fields directly onto the canvas or into the Visualizations pane
Field ordering
Power BI sorts fields alphabetically by default within each table. You can reorder them in the Data view by dragging — useful when you want measures at the top.
Visualizations Pane¶
Two tabs: 1. Build visual — choose chart type, then assign fields to visual-specific slots (Axis, Values, Legend, Tooltips) 2. Format visual — all formatting options organized by category (general, visual, colors, title, legend, X-axis, Y-axis, data labels)
For mid-level analysts
The Format pane is where report polish happens. Learn to navigate it quickly: conditional formatting (right-click a value field in the Build tab), data label formatting, and title customization account for 80% of professional-looking reports.
Filters Pane¶
Three filter levels: 1. Visual-level filter — applies only to the selected visual 2. Page-level filter — applies to all visuals on the current page 3. Report-level filter — applies to all visuals on all pages
Filters pane vs slicers
The Filters pane is for the report builder. Slicers are for the end user. If you hide the Filters pane (common in production reports), users can only interact via slicers. Make sure every user-facing filter has a corresponding slicer.
The Ribbon¶
The ribbon has five main tabs in Desktop:
| Tab | Key actions |
|---|---|
| Home | Get Data, Transform Data, New Measure, New Table, Publish |
| Insert | New page, Text box, Buttons, Shapes, Images, Q&A visual |
| Modeling | New Measure, New Column, New Table, Manage relationships, Row-level security |
| View | Themes, Gridlines, Snap to grid, Performance analyzer, Sync slicers |
| Help | Training, Community, Submit feedback |
Report Page vs Dashboard¶
This distinction trips up beginners constantly.
| Report Page | Dashboard | |
|---|---|---|
| Built in | Power BI Desktop or Service | Power BI Service only |
| Content | Visuals you create and configure | Visuals pinned from reports |
| Interactivity | Full filtering, drill-down, slicers | Limited — clicking takes you to the underlying report |
| Purpose | Analysis and exploration | High-level monitoring (one-screen summary) |
| Mobile layout | Configurable | Auto-arranged |
Decision rule
Build reports for analysis. Build dashboards for executive monitoring. Dashboards are snapshots; reports are tools.
Keyboard Shortcuts Worth Knowing¶
| Action | Shortcut |
|---|---|
| Undo | Ctrl+Z |
| Redo | Ctrl+Y |
| Select all visuals | Ctrl+A |
| Multi-select visuals | Ctrl+click |
| Open Performance Analyzer | Alt+Shift+P |
| Save | Ctrl+S |
| Publish | Alt+F4 is not save — use the Publish button |
Common First-Day Mistakes¶
Working in Service when you should be in Desktop
Power BI Service has a report editor, but it is more limited than Desktop. Build your report in Desktop, publish to Service, and use Service only for sharing and scheduling.
Ignoring data types
If a date column imports as text, every date filter and time intelligence measure will fail silently. Always check data types in the Data view immediately after connecting.
Previous: 00-agenda | Next: 02-connecting-data