A list of the updates made in the April 2017 update to Power BI Desktop
Part six of a six-part series of blogs

This update includes some nice new features - for example, creating columns by example and changing chart axis titles. Read this blog for a full list!

  1. Updates in the April 2017 Edition of Power BI Desktop
  2. You can now change the axis titles
  3. Splitting Columns, and Putting the Results into Rows
  4. Creating columns by example
  5. Simplified Group By Transform in Query Editor
  6. Quick Way to Select a Column in Query Editor (this blog)

For a cumulative list of all of the updates to Power BI Desktop in the last few months, see this blog.

Posted by Andy Brown on 28 April 2017

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Quick Way to Select a Column in Query Editor

So sometimes last IS least.  It's only a tiny thing, but you can now select a column easily when there are too many to see on one screen:

Go to column

Choose this menu on the HOME tab in Query Editor.

Initially you see a list of all the columns in the table:

Columns in table

You can double-click on the column you want to go to.

 

Typing in a search string allows you to go to a specific column very quickly:

Searching for a column

This facility works really quickly (here we're showing all columns whose titles contain the letters di).

 

Bingo!

Director name selected

OK, so on this occasion it might have been quicker just to click on the column to select it ...

And that's the end of this look at tthe non-preview features in this update!

This blog has 0 threads Add post