Power BITutorials

How to Navigate Query Editor Using Power Query

1 Mins read
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

[xyz-ihs snippet=”Business-Analyst-Course”]

 

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
ExcelTutorials

249+ MS Excel Shortcuts Keys in PDF | Excel Keyboard Shortcuts

11 Mins read
ExcelTutorials

How to Find Duplicate Values in Excel

2 Mins read
ExcelTutorials

How to Lock Formulas in Excel?

2 Mins read
Power your team with Yoda Learning

[mc4wp_form id="17"]

Add some text to explain benefits of
subscripton on your services.