BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
This update includes lots of nice features, such as line markers and the ability to change font typefaces, as well as many more changes!
- Changes for the June 2017 update for Power BI Desktop
- Data Bars in the Preview Table and Matrix Visualisations (this blog)
- Chart Line Markers and Line Effects
- Making reports accessible to people with disabilities
- Changes to maps
- Improvements to the Column by Example feature
- Horizontal slicers can now contain images
- Font family support for visuals
- Changes for combination charts
For a cumulative list of all of the updates to Power BI Desktop in the last few months, see this blog.
Posted by Andy Brown on 26 June 2017
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.
Data Bars in the Preview Table and Matrix Visualisations
It's becoming increasingly hard to ignore the new table and matrix visuals, which have been lurking in preview mode for some months now. Not only do they support drill-down, but now you can create data bars too:
Data bars can display from left to right (the default), or - as here - right to left.
Remember - you can only use these if you enable the preview table and matrix visuals.
Getting at the Data Bars
Like conditional formatting, data bars are unusual in that you can get at them from either the field well or the formatting toolbar. So you can right-click on a field in the field well:
Here I right-clicked in the numerical Sales field.
But you can also use the Format toolbar:
You can turn data bars on in the Conditional formatting section of the Format toolbar. Note that you have to click on the Advanced controls link to format data bars (Microsoft obviously decided this toolbar is getting too cluttered).
Customising your Data Bars
For now, there's not a huge amount you can do to configure your data bars:
Here I've set the minimum amount to be 0, rather than the minimum sales value, and I've changed the default colour scheme.
I suspect Microsoft will add to this dialog box over the coming months.
- Changes for the June 2017 update for Power BI Desktop
- Data Bars in the Preview Table and Matrix Visualisations (this blog)
- Chart Line Markers and Line Effects
- Making reports accessible to people with disabilities
- Changes to maps
- Improvements to the Column by Example feature
- Horizontal slicers can now contain images
- Font family support for visuals
- Changes for combination charts