The most important changes made for the May 2017 Power BI Desktop update
Part five of a seven-part series of blogs

The May 2017 Power BI Update brings in a couple of nice new query transforms and some new chart features, but the big changes are still in preview mode.

  1. Updates in the May 2017 Edition of Power BI Desktop
  2. Support for Different Types of URLs in Tables and Textboxes
  3. New Table and Matrix Visualisations in the Offing
  4. Extracting Text Between Delimiters
  5. New Binning Options (this blog)
  6. Data labels in combination charts
  7. Combining Files - Option to Choose First File

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 17 May 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.

New Binning Options

As a reminder for those of you who don't bin every day, here's what it means and how to do it:

Creating a bin

To bin data, right-click on a data field in Data view, and choose to create a new group for it.

Much has changed in the binning dialog box which appears:

The new binning dialog box

As an example, Power BI Desktop now shows the minimum and maximum values for your data.

Power BI Desktop also now recommends a bin size, using this formula:

The Rice rule

The Rice rule: n is the number of data points in your data.

 

I only mention this because it looks pseudo-scientific: suffice it to say that you'll get more help choosing your bin size.

This blog has 0 threads Add post