NEW! FREE 90 Minutes Excel Charts Course for Reporting Watch now 

Power BITutorials

How to Navigate Query Editor Using Power Query

1 Mins read

While using Power Query, you might’ve come across a step that reads ‘Navigation’  in Applied Steps pane and it is automatically created by Power Query. But, do you know what it is used for?

Navigate Query Editor Using Power Query

The code generated by this step is = Source{[Item=”Sheet1″,Kind=”Sheet”]}[Data]

This is one of the ways that Power Query automatically creates a navigation step, but there are other ways to create this step and depending on the situation Power Query might create a different code.

There are three types of navigations in Power Query viz. Column Navigation, Row Navigation, and Cell Navigation.

Let us refer to the below steps to study all these navigation types.

Step 1: Drill Down Column

To navigate to a specific column, you should simply right-click on that column and select the ‘Drill Down’ option as shown below.

DRILL DOWN COLUMN

Step 2: Drill Down Row

To navigate to a specific row, you should select that row simply right-clicks to select the ‘Drill Down’ option as shown below.

DRILL DOWN ROW

When you click on Drill down option, Power Query will only navigate for a specific column. To drill down the complete row, remove the column name from the formula in the formula bar and only keep = #”Changed Type”{0}

Step 3: Drill Down Cell

You can also right-click on any cell that you want to navigate and would get the ‘Drill Down’ option as well.

You can learn more : 

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…