Browse 547 attributed reviews, viewable separately for our classroom and online training
Power BI July 2021 Update
Part three of a four-part series of blogs

This month's update sees the launch of small multiples, a range of new dynamic format properties and the roll-out of sensitivity labels.

  1. Power BI July 2021 Update
  2. Small multiples
  3. Lots more conditional properties available (this blog)
  4. Sensitivity Labels

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 26 July 2021

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Lots more conditional properties available

I haven't done any research on this, but I would guess Power BI has now reached a tipping point where over half of the useful formatting properties can be dynamic (that is, their value can change according to what's being displayed).

The new conditionally formattable properties

You can now apply conditional formatting to the following new properties:

Area Properties
Labels Data labels and total labels
Legend Legend text colours
Axes Start and end values, axis title, gridline and label colours
Funnel charts Visual percentage bar label colours and category axis colours
Multi-row cards Title text, data label colours and category label colours
Gauges Visual axis colours (including start, minimum and maximum colours)
Slicers Slider colour and header font colours

You can see this full list at the Microsoft Power BI July 2021 update page.

Example of a new conditional formatting property - axis titles

Suppose that you want to colour-code your axis labels.  For example:

Land is green

If you select the Land environment the labels appear in green ...

Or:

Water is blue

... whereas if you select the Water environment axis labels appear in blue.

Creating the necessary measure

Here's a measure that you could use to achieve this:

Colour measure

If the user has selected a single environment, show it as lime green, blue or yellow; otherwise, show the colour as maroon (dark red).

 

This shows the basic problem with using conditional formatting: to use it effectively you're going to have to learn DAX, which is (as they used to say) a completely different kettle of fish to report creation.

Applying the conditional format

Wherever you see the fx symbol you can make a property dynamic:

X axis label colour

Here we want to change the axis label colour to be the value of our measure.

 

Click on the icon shown above to set the axis colour to depend on the selected environment:

Setting a measure

Choose the measure you've created.

 

One of the most interesting new conditional formats available is that you can now change the minimum and maximum values for the scaling of the X and/or Y axes to vary according to the selected data.

  1. Power BI July 2021 Update
  2. Small multiples
  3. Lots more conditional properties available (this blog)
  4. Sensitivity Labels
This blog has 0 threads Add post