Changes to Power BI in the January and February 2019 updates
Part four of a seven-part series of blogs

There wasn't an official January update, although there were improvements announced to Power BI Service. This blog lists these, and also new features to wrap titles in visuals, apply rounded corners and change the default way in which visuals interact with each other.

  1. Power BI Updates for January and February 2019
  2. Word wrapping titles in visuals
  3. Rounded borders
  4. Improvements to the way visuals interact with each other (this blog)
  5. Scheduled (time-based) subscriptions for your reports
  6. Miscellaneous updates to Power BI Service
  7. Power BI features waiting in preview, as of February 2019

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 15 February 2019

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.

Improvements to the way visuals interact with each other

This update brings two changes to how visuals interact with each other: one large, one small.  Let's start with the large one!

Changing the default interaction method

It's always seemed odd to me that the default visual interaction setting is to highlight, rather than to filter.  Here's what this means:

Selecting a region

Suppose I select the Yorkshire & Humberside region. What should happen to other visuals?

The default is that they should highlight this region's data:

Highlighting regional data

The default option for any visual is to highlight data for any selection made in a separate visual.

A better default, I think, would be to filter data:

Filtering data

Notice how with Filter applied as the visual interaction method the numbers are much smaller in the scale on the left-hand side - this is because this visual is now showing only Yorkshire & Humberside data, since this is the region selected in the other visual.

If you agree with me, you can now change the default setting!  Just go into Power BI options:

Power BI options

Select this option from the File menu.

 

You can now change the default setting for cross-filtering:

Report setting

Tick this box on the Report settings tab.

I'd say this was worth it!

Cross-filtering single points on line charts

I did say the second change was small.  You can now select a single point on a line chart, and other visuals will filter to show this point's data:

2014 data

If you click on this point, other visuals on the chart will show only data for 2014.

I confess that I had assumed that this was already the way things worked! 

This blog has 0 threads Add post