This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Changes for the May 2022 Power BI Desktop update Part three of a five-part series of blogs
Small improvements this month, but welcome ones - particularly the ability to zoom in and out, and to select data points in (some) charts using a selection rectangle. Changes for the May 2022 Power BI Desktop update You can now zoom in and out in Power BI Desktop! Lassoing data points using a rectangle for a chart (this blog) Automatically expanding all formatting categories ArcGIS has improved - apparently We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Changes for the May 2022 Power BI Desktop update

Part three of a five-part series of blogs

Small improvements this month, but welcome ones - particularly the ability to zoom in and out, and to select data points in (some) charts using a selection rectangle.

Changes for the May 2022 Power BI Desktop update
You can now zoom in and out in Power BI Desktop!
Lassoing data points using a rectangle for a chart (this blog)
Automatically expanding all formatting categories
ArcGIS has improved - apparently

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 30 May 2022

Lassoing data points using a rectangle for a chart

Suppose that you want to select all of the data points shown in the following chart:

You want to select all of the data points apart from the Water environment ones.

This would give you the following rows in a separate table:

Visual interaction implies that you would see data for all of the shopping centres in Preston, but only two of the environments.

You can now do this by judicious use of the Ctrl and Shift keys. Start by selecting all of the left data points:

Start with your mouse pointer here, for example.

Holding down the Ctrl key, click and drag with your mouse:

Provided you have the Ctrl key held down, this will select the Land points.

You can now hold down the Shift key to add to your current selection, and hold down the Ctrl key to also select the Air data points:

It's easier to do than to describe!

My original version of this blog used a column chart, but I've since realised that - sadly - you can only use a rectangle to select data points like this in an area, line, scatter, treemap or map visual.

Parts of this blog
Changes for the May 2022 Power BI Desktop update You can now zoom in and out in Power BI Desktop! Lassoing data points using a rectangle for a chart (this blog) Automatically expanding all formatting categories ArcGIS has improved - apparently