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
550 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 three 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. |
How much of your life do you want to devote to formatting your chart data labels? Not as much as Microsoft would like, we suspect:
Here each data label shows a Title, Value and Detail component.
It's great that Microsoft are providing new ways to format parts of a chart, but there is a line you can cross between ease-of-use and stuffing yet more options onto an already crowded formatting palette, and this author thinks that with this update Microsoft have crossed this line!
Here are the options chosen above for formatting the title of our data labels:
Notice that you can change the title (as we've done) to show any data field you like. Here we're showing the first (and only) centre type name for each bar.
The green values in our chart are given by this:
The values will appear in green.
Notice that we've used custom formatting to precede each value with the words Total sales, and to suffix it with units;
The custom formatting improves the appearance of our value.
The final (blue) part of our data label is an optional Details one:
Again we've used a custom formatting code to display something (in this case, the average price of sales for each centre type).
Our chart also uses the following additional formatting:
The background of the data labels appears as orange, and the labels will occupy different lines.
What is really mind-blowing is that you can apply different data labels to each series of a chart, meaning that you could comfortably spend an entire morning just getting the data labels of one chart to look just right!
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.