The main new features for BI workers in the November 2016 Power BI update
Part six of a seven-part series of blogs

A summary of the new features in the November 2016 Power BI Update, omitting things which are still only in preview.

  1. Power BI Desktop - November 2016 update
  2. Dropdown slicers - the new list option
  3. Conditional formatting now available for matrices
  4. Formatting table and matrix columns
  5. Changing the colour of axis titles and labels
  6. Prevent hierarchy axis label concatenation (this blog)
  7. Forecasting now extended to Power BI Service

You can see a list of all updates going back to November 2016 (this update) here.

Posted by Andy Brown on 19 December 2016

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.

Prevent hierarchy axis label concatenation

This is such an exotic change that it needs the scene setting!  Imagine that you have a shopping database, and include in a single table the region, town and shopping centre in which transactions take place.  You can then create a hierarchy based on these 3 columns:

The geography hierarchy

You can right-click in the field well to create a hierarchy, then drag fields into it (not shown here).

 

You could now use this to create a chart:

Chart using hierarchy

The chart uses the hierarchy for its axis.

 

You could then drill-down to show all of the levels of the hierarchy on a single chart:

Showing all hierarchy levels

Click on the symbol shown to expand the hierarchy.

Here's what you get by default:

Concatenated labels

The labels are impossible to read, consisting as they do of the region, town and centre name concatenated together.

So now you can turn this feature off:

X-Axis properties

In the X-Axis formatting properties, turn Concatenate labels off.

 

Much better!

Without concatenation

What the chart then displays as.

Not earth-shattering, but a welcome (if tiny) change ... 

This blog has 0 threads Add post