Dashboard Mode - Power Query interface overview
Goal
Understand the main parts of the Power Query interface to prepare and clean data for analysis.
0
0
Power Query interface overview in Power BI - Dashboard Guide
Sample Data
| Order ID | Product | Quantity | Price | Date |
|---|---|---|---|---|
| 1001 | Notebook | 2 | 5.00 | 2024-01-10 |
| 1002 | Pen | 10 | 1.50 | 2024-01-11 |
| 1003 | Folder | 5 | 3.00 | 2024-01-12 |
| 1004 | Notebook | 1 | 5.00 | 2024-01-13 |
| 1005 | Pen | 20 | 1.50 | 2024-01-14 |
Dashboard Components
- Query Settings Pane: Shows applied steps like filtering or adding columns. Helps track changes.
- Data Preview Grid: Displays sample rows of data after each step. Lets you see changes live.
- Ribbon Toolbar: Contains buttons for common tasks like removing columns, changing data types, or merging tables.
- Formula Bar: Shows the formula for the current step. You can edit it to customize transformations.
- Queries Pane: Lists all queries in the workbook or report. You can select and manage queries here.
Dashboard Layout
+-------------------------------------------------+ | Ribbon Toolbar | +----------------+----------------+--------------+ | Queries Pane | Data Preview | Formula Bar | | | Grid | | | | | | +----------------+----------------+--------------+ | Query Settings Pane | +-------------------------------------------------+
Interactivity
When you select a query in the Queries Pane, the Data Preview Grid updates to show that query's data. Changes made using the Ribbon Toolbar or Formula Bar update the Data Preview and add steps in the Query Settings Pane. This keeps all parts connected and shows your data transformation progress.
Self Check
If you filter rows in the Data Preview Grid, which parts of the interface update to reflect this change?
- Query Settings Pane shows a new filtering step.
- Formula Bar updates with the filter formula.
- Data Preview Grid shows filtered data.
Key Result
Overview of Power Query interface parts and how they work together to transform data.