562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
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.
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|
25 Aytoun Street