BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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!
- Updates in the April 2017 Edition of Power BI Desktop
- You can now change the axis titles
- Splitting Columns, and Putting the Results into Rows
- Creating columns by example
- Simplified Group By Transform in Query Editor
- 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:
Choose this menu on the HOME tab in Query Editor.
Initially you see a list of all the columns in the 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:
This facility works really quickly (here we're showing all columns whose titles contain the letters di).
Bingo!
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!
- Updates in the April 2017 Edition of Power BI Desktop
- You can now change the axis titles
- Splitting Columns, and Putting the Results into Rows
- Creating columns by example
- Simplified Group By Transform in Query Editor
- Quick Way to Select a Column in Query Editor (this blog)