New features in the November 2018 update of Power BI Desktop
Part eight of an eight-part series of blogs

A big new update this month, including expandable row headings in matrices, copying and pasting between visuals and conditional formatting of charts (although it's what's waiting in preview which will really blow your mind).

  1. Changes introduced in the November 2018 Power BI update
  2. Expandable row headers in matrices
  3. Conditional colours now apply to charts too
  4. Copying and pasting visuals between Power BI reports
  5. Asking related questions in the Q and A Explorer
  6. Composite models and many-to-many relationships
  7. Preview - relationship diagrams and new ways to filter
  8. Summary of features waiting in preview - November 2018 (this blog)

For a cumulative list of all of the updates to Power BI Desktop in the last few year or two, see this blog, or have a look at the Power BI courses that we run.

Posted by Andy Brown on 26 November 2018

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.

Summary of features waiting in preview - November 2018

Two behemoths have muscled their way into preview - a new modelling view, and a new filter pane:

Preview features November 2018

Some old friends, and two welcome new ones at the bottom!

 

Here's my usual take on how each of the above features might affect your working life:

Feature Notes Rating Months
Shape map visual Why won't Microsoft release this?  It seems to work fine, and I've been demonstrating it for months now. 4 10
M Intellisense Guessing your way round the M language (used to manipulate data loaded into your data model using Query Editor) will become much easier when this is introduced. 8 3
Spanish language support for Q&A Will Power BI show better answers when you put your question in Spanish?  Time will tell - hasta luego. 2 10
Get data from PDF files Impressively, you'll be able to load data into a model from tables in a PDF file. 7 3
Enable column profiling Query Editor will assess the quality of data when you import a column and list possible errors. 8 2
Dates as a hierarchy When you create a date hierarchy, this will appear in the field well. 2 10
Python support The ability to specify a Python program which outputs data as a data source. 3 4
Incremental Refresh Policies For Power BI Premium only, to begin with, you'll be able to update only data which has changed. 7 7
Manage aggregations You will be able to load data at a summarised level into a data model (thus taking up far less space), while still allowing users to drill down to a lower level. 6 3
Enable fuzzy merge You'll be able to control how similar items have to be to be considered the same when merging data. 6 2
Modelling view A whole new way of looking at relationships, which will also give you the ability to apply changes to multiple fields/tables at the same time. 9 1
New filter experience A new customisable and easy-to-use filter pane, with filters that you can lock and hide. 9 1

Notes:

  1. The subjective Wise Owl rating goes from 1 (of little importance for most Power BI Desktop users) up to 10 (will have a huge impact on your everyday report designs).
  2. The final column shows the number of months that each feature has spent in preview since I started tracking it.
This blog has 0 threads Add post