559 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 in the February 2023 Power BI Update
Part three of an eight-part series of blogs
There are quite a few changes in this month's update, but none of them will change your life that much!
Suppose that you want to format all of the regions in a chart in the North of England blue:
Both North and North West begin with North, so we colour them blue.
Previously you would have had to create a calculated column (or a column in Query Editor) setting the colour:
Having created this column, you could then use this as the Field for conditional formatting.
Things are now much easier!
Start by setting conditional formatting:
Click on this icon to set conditional formatting (here for column colours in a chart).
You can then choose to set a rule:
Here our rule is that the region should start with North (and if it does, the colour used should be blue).
As always, the First RegionName is confusing to those not familiar with filter context (and even to those who are). You may not see why you need the word First - Power BI adds because you always have to perform some aggregation function.
The most obvious thing which may go wrong is case-sensitivity:
Here one of our regions is in capitals.
Currently there is no option to do case-insensitive text comparisons for conditional formatting:
We've lost the NORTH region, because it no longer starts with North.
Hopefully Microsoft will add a case-insensitive tick box to this option some time soon!
In the meantime, the only solution I can think of is to add a calculated column converting things to upper or lower case, somewhat defeating the point of this new feature!
|Parts of this blog|
25 Aytoun Street