WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
A list of the updates made in the April 2017 update to Power BI Desktop
Part five 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 (this blog)
  6. Quick Way to Select a Column in Query Editor

For a cumulative list of all of the updates to Power BI Desktop since November 2016 see this blog, or have a look at the Power BI courses that we run.

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.

Simplified Group By Transform in Query Editor

I've always found the Group By transform hard to use:

The Group By transform

The Group By transform in the Power BI Desktop Query Editor.


Someone at Microsoft agreed, because it now has a basic mode:

Basic Group By

This is the dialog box which now appears by default, which works when you just want to have two columns in the final results.

Using this, it's easy to choose what you want to do:

Counting rows

Here I'm counting the number of films for each certificate.

This would give two columns:

The resulting table

Since most group by transforms only return two columns, the basic mode should be useful.


A small contribution to the betterment of humanity!

This blog has 0 threads Add post