BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
The December 2019 update allows you to customise your visuals pane and format KPIs better, but that's almost it!
- Power BI Updates for December 2019
- Customising the Visualisations Pane
- Many More KPI Formatting Options (this blog)
- Conditional Formatting for Table/Matrix Values as URLs
- New DAX Quarter Function
- 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:

The indicator is right-aligned, and the text for the goal has been changed.
Here are the indicator formatting options for this:

I've set the indicator text to be at the bottom right of the KPI.
You can change the trend axis transparency:

I've made the background mountain range a bit less transparent.
You can also change the text and formatting for 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:

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):

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!
- Power BI Updates for December 2019
- Customising the Visualisations Pane
- Many More KPI Formatting Options (this blog)
- Conditional Formatting for Table/Matrix Values as URLs
- New DAX Quarter Function
- The Power BI Features Waiting in Preview