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 (this blog)
- Creating columns by example
- Simplified Group By Transform in Query Editor
- Quick Way to Select a Column in Query Editor
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.
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:

The rows to be loaded.
Here's what this gives in Query Editor, after adjustment:

The countries awaiting splitting.
You can now choose to split these by comma, and store the results in rows:

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:

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!
- 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 (this blog)
- Creating columns by example
- Simplified Group By Transform in Query Editor
- Quick Way to Select a Column in Query Editor