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
549 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 ...
What's new in the March 2024 Power BI Desktop update Part two of a four-part series of blogs |
---|
There are updates to on-object interactions and visual calculations this month, but these major new features still remain in preview. This leaves small changes to data bar and data label formatting - and a new way of doing row-level security - as the only signficant changes in this month's update.
We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses. |
This seems like a feature which would be low down on anyone's request list. It also - surely - currently contains a bug, although read on to see if you agree.
The new feature allows you to extend data bars like this to include the totals in a table or matrix.
So here's how this works. Find the Cell elements formatting card with a table or matrix like the one above selected, and apply Data bars:
Choose a numeric column (here we've chosen Quantity sold) then turn data bars on.
If you then click on the standard fx button shown above, you'll be able to customise how these data bars appear:
For this example I'm going to choose Values and totals.
The moment you do this, the OK button is greyed out:
Computer says ... no.
The only way to proceed seems to be to set a minimum and maximum quantity:
Here I've set the minimum to 0 and the maximum to 80000, and I can proceed.
The total is included when calculating the data bars:
Because the total is (obviously) bigger than all of the component data bars it has a much wider bar than any other cell.
If (like me) you are wondering what Totals only would mean for the above context, the answer is ... not much!
For a table, showing data bars for Totals only is pointless.
Totals only does have some meaning for a matrix:
Data bars make sense when comparing more than one number.
Why should you have to set a minimum and maximum threshold for your data bars when they include totals? I can't work out if this restriction is a bug or a necessary feature. Can anyone throw any more light on this?
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.