Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers 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
Search our website
We also send out useful tips in a monthly email newsletter ...
The December 2023 update to Power BI Desktop Part two of a four-part series of blogs |
---|
This update includes lots of updates to the formatting of bar/column charts, even more data label formatting options and better clustered bubble chart formatting for Azure Maps.
We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses. |
In this blog
There are a slew of new formatting options for bar, column and ribbon charts:
An example: in the bottom chart we've increased the spacing between data series and added a green semi-transparent background and green border for the Grasslands series only. None of this was possible before this update!
You can now choose to which bar or column you want an extensive range of formatting options to apply:
Here we're formatting only the Grasslands bar.
You can then change a host of options:
Here we're setting the background colour to semi-transparent green and the border colour to a 2-pixel thick dark green border.
Notice that there's also a nice option for the border colour to match the bar colour, so you can set the background colour to (say) a semi-transparent purple and easily set the border colour to match this.
To do this you must first ensure you have all series selected:
This new Layout card consolidates lots of options previously on the Spacing card, but also allows you to space out your bars/columns by up to 5 pixels (or explode them in the same way as you can explode a pie chart's slices).
A ribbon chart is a variant of a bar/column chart, and so also gets new formatting options:
We have (somewhat unwisely) formatted the Grasslands ribbon within inches of its life.
Here are some of the optons for doing this:
The options are the same as the ones shown for bar/column charts above.
Note the bug: even though we've changed the series colour for Grassland, this is still showing up as unselected.
Parts of this blog |
---|
|
Some other pages relevant to the above blogs include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.