WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 525 reviews for our classroom and online training
A summary of the main changes introduced in the December 2019 Power BI update
Part three of a six-part series of blogs

The December 2019 update allows you to customise your visuals pane and format KPIs better, but that's almost it!

  1. Power BI Updates for December 2019
  2. Customising the Visualisations Pane
  3. Many More KPI Formatting Options (this blog)
  4. Conditional Formatting for Table/Matrix Values as URLs
  5. New DAX Quarter Function
  6. The Power BI Features Waiting in Preview

For a cumulative list of all of the updates to Power BI Desktop in the last few years see this blog, or have a look at the Power BI courses that we run.

Posted by Andy Brown on 23 December 2019

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.

Many More KPI Formatting Options

If you like the KPI visual, you'll love the fact that you can now format it much better.  The options below created this KPI:

Formatted KPI

The indicator is right-aligned, and the text for the goal has been changed.


Here are the indicator formatting options for this:

Indicator formatting

I've set the indicator text to be at the bottom right of the KPI.


You can change the trend axis transparency:

Trend axis formatting

I've made the background mountain range a bit less transparent.


You can also change the text and formatting for the goal:

Formatting the goal

I've set the goal to appear in red, with some detailed text labelling it.


For the colour coding (as for some other KPI formatting properties) you can set conditional formatting:

KPI colour coding

You could make the colours used by your KPI depend on the value of some measures in your data model.


Finally, I've set the date field formatting (without I confess quite understanding what a date is for a KPI):

Date field formatting

The date appears in a purplish colour.


I began the sentence with the words If you like the KPI visual, you'll love the fact that you can now format it much better.  I must admit I DON'T particularly like the KPI visual, but hopefully there are others out there who do! 

This blog has 0 threads Add post