BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
This month's update sees the launch of small multiples, a range of new dynamic format properties and the roll-out of sensitivity labels.
- Power BI July 2021 Update
- Small multiples
- Lots more conditional properties available (this blog)
- Sensitivity Labels
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:
|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:
If you select the Land environment the labels appear in green ...
... 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:
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:
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:
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.