This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

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! Changes in the February 2023 Power BI Update The new relationship editor Conditional formatting based on string values (this blog) Choosing pages to show in the Page Navigator visual Indenting text in textboxes New accessibility themes Two new DAX functions: LINEST and LINESTX You can now change image height and width separately We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

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!

Changes in the February 2023 Power BI Update
The new relationship editor
Conditional formatting based on string values (this blog)
Choosing pages to show in the Page Navigator visual
Indenting text in textboxes
New accessibility themes
Two new DAX functions: LINEST and LINESTX
You can now change image height and width separately

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 28 February 2023

In this blog

How to use text-based conditional formatting
What may go wrong

Conditional formatting based on string values

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!

How to use text-based conditional formatting

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.

What may go wrong

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
Changes in the February 2023 Power BI Update The new relationship editor Conditional formatting based on string values (this blog) Choosing pages to show in the Page Navigator visual Indenting text in textboxes New accessibility themes Two new DAX functions: LINEST and LINESTX You can now change image height and width separately