BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
You can now search for formatting properties, have slicers which work across pages and create quick measures, among other new features.
- Power BI Desktop - February 2018 update new features
- Search for a formatting property
- Quick Measures
- Synchronising slicers across report pages
- Multi-select data points in a chart
- Overflow data labels (this blog)
- Marking date tables as such
- Extra DAX functions
- Features still in preview as of February 2018
For a cumulative list of all of the updates to Power BI Desktop in the last few year or two, see this blog. Our two-day Power BI Desktop course always uses the latest version of the software.
Posted by Andy Brown on 15 February 2018
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.
Overflow data labels
This is an easy feature to explain, but a hard one to reproduce! By default, data labels showing inside a column or bar will only appear if there's sufficient space:
Here the only column big enough to display the data label is the one for the South-East region.
To change the behaviour of data labels, turn the background colour on:
Turn on the Show background property to change how your data labels appear.
The good news is that you can now see all of your data labels, but the bad news is that they've moved out of their boxes:
Data labels outside their boxes!
If you now set the Overflow text property, the data labels will appear inside the box again.
By showing labels' backgrounds and letting their text overflow, you'll get this effect:
You can tell Power BI Desktop to let data labels overflow, so that you always see a label even if it wouldn't otherwise fit into the relevant column or bar.
I couldn't get this to work without first setting the Show background property, but it's possible I'm missing something. In any case, it's hardly a feature to write home about ...
- Power BI Desktop - February 2018 update new features
- Search for a formatting property
- Quick Measures
- Synchronising slicers across report pages
- Multi-select data points in a chart
- Overflow data labels (this blog)
- Marking date tables as such
- Extra DAX functions
- Features still in preview as of February 2018