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