WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 525 reviews for our classroom and online training
A list of the updates made in the April 2017 update to Power BI Desktop
Part three 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 (this blog)
  4. Creating columns by example
  5. Simplified Group By Transform in Query Editor
  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.

Splitting Columns, and Putting the Results into Rows

This is a clever feature which turns lines of values into a table.  It's easiest to understand by example.  Suppose that you're loading this modest Excel workbook into Power BI Desktop:

Countries to import

The rows to be loaded.


Here's what this gives in Query Editor, after adjustment:

Countries loaded

The countries awaiting splitting.


You can now choose to split these by comma, and store the results in rows:

Advanced options

Click on the Advanced options icon (as shown here), and choose to split the data into rows, not columns.


Here's what Power BI Desktop will show for this example:

Table with rows

The countries have been split into different rows.


What I can't work out is what the quote character is for, as it seems to make no difference what option you choose for it!

This blog has 0 threads Add post