BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
New features introduced into Power BI Desktop in this update include conditional formatting by different fields, the inclusion of filters in drill-through and minor improvements to line and funnel charts.
- Power BI Desktop - May 2018 update new features
- Conditional formatting by different fields
- Drill-through uses all field values and works with measures
- Various improvements to charts (this blog)
- Improvements to slicer syncing
- Features still in preview as of May 2018
Posted by Andy Brown on 14 May 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.
Various improvements to charts
This page shows 3 small improvements made to charts for this update:
- You can now set a line chart to have an invisible line (or zero stroke width).
- You can show data labels within the blocks of a funnel chart.
- Log axes now work properly.
Below is an explanation and example for each change.
Line charts which don't have lines
Line charts with lines look very different to line charts without them!
This line chart shows for each year the highest and average number of sales.
However, you can now set the line stroke width to 0:
A zero width line.
Here's what the result looks like:
A line chart without a line (just markers).
Note that to reproduce this example I had to change the x-axis Type property from Continuous to Categorical, so that I could display markers.
Data labels in a funnel chart
A neat feature is that you can show for each bar of a funnel chart what percentage it constitutes of the previous one:
Here I've chosen Percent of previous.
Here's what the result might look like:
Power BI only displays the labels within the bars when there is room to do so.
Log axes now working properly
Providing that all of your values are positive, these help show a chart where one value is far more than the others:
In this chart the Shopping Centre figures dwarf the others, and makes comparisons difficult.
You've been able to show this as a log chart for some time:
You can change the Scale type to Log to flatten out effects.
This makes your chart look very different:
I'm not convinced that this is a meaningful way to compare sales data by centre type, but it does illustrate log charts!
So this isn't a new feature, but an improved one. Here's what Microsoft have to say on the subject: "While we have supported (using a) log axis for a very long time, the support has been inconsistent across charts and could sometimes be hard to use".
If your chart includes negative values, you get a warning message in the properties pane:
Mysteriously, we've managed to make negative sales for one of our centre types.
Here's the warning message:
Note that although the triangle symbol always appears, it seems to be hard to get the popup caption to appear (sometimes it flashes in the background only). No doubt this is a tiny bug which will be ironed out very soon.