New features in the November 2018 update of Power BI Desktop
Part seven 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 (this blog)
  8. Summary of features waiting in preview - November 2018

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.

Preview - relationship diagrams and new ways to filter

I normally try to avoid blogging about features still in preview, but there are two new announcements this month which are so huge that I thought they deserved a mention.

Two preview features

The two new features as they appear in preview.

 

New modelling view

So this will change my life, if not yours.  Here's a glimpse into the near future!

Want to change the format of lots of measures at the same time?  Just select them:

Select all measues

You'll be able to click on the three dots to select all the measures in a table.

 

You can then change the format properties for all of the measures you have selected:

Multiple properties

For this example, you could set both selected measures to have the same format.

Want to hide lots of columns (or tables) in one go?  You will be able to!

Hiding multiple objects

This works in the new feature! Let's not get too antsy about the fact that PowerPivot has allowed you to do this for several years now ...

 

You'll be able to create new relationships diagrams:

Auto arrange

This diagram speaks for itself!

Yup, there's a lot to look forward to!

New filter pane

If you turn this preview feature on, a little eye symbol appears to the right of the filter panel:

Filter pane eye

Be warned that this symbol only appears with new reports that you create, not for existing ones.

 

A new pane then appears:

New filter pane

The new-look filter pane, which initially is empty.

Here's a sample filter:

Filtering by environment

I'm about to choose to see only Air and Water sales.

 

The results are displayed concisely:

Air or water filter

The filter pane contents are kept as short as possible, to make things less confusing for users of your reports.

 

You will be able to format the filter pane:

Formatting the filter pane

Hopefully you'll choose better colours than this!

One nice touch is that you can use themes to control the look of filter panes, just like for any other part of your report.

You can also change the formatting of filter cards:

Filter cards Formatted filter card
Formatting filter cards Typical results

You'll be able to lock filters, or even hide them:

Locking filters

Locking a filter will mean that a report consumer can't change it.

 

Being in preview it seems to me that there are still a few features to iron out, but I'm excited to see this in the production copy of Power BI Desktop.

This blog has 0 threads Add post