WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
The most important changes included in the June 2017 Power BI Desktop update
Part two of a nine-part series of blogs

This update includes lots of nice features, such as line markers and the ability to change font typefaces, as well as many more changes!

  1. Changes for the June 2017 update for Power BI Desktop
  2. Data Bars in the Preview Table and Matrix Visualisations (this blog)
  3. Chart Line Markers and Line Effects
  4. Making reports accessible to people with disabilities
  5. Changes to maps
  6. Improvements to the Column by Example feature
  7. Horizontal slicers can now contain images
  8. Font family support for visuals
  9. Changes for combination charts

For a cumulative list of all of the updates to Power BI Desktop since November 2016 see this blog, or have a look at the Power BI courses that we run.

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

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:

Showing data bars

Here I right-clicked in the numerical Sales field.

But you can also use the Format toolbar:

The Formatting data bars

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:

Configure 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. 

This blog has 0 threads Add post