The main new features for BI workers in the November 2016 Power BI update
Part two 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 (this blog)
  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
  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.

Dropdown slicers - the new list option

So here's a slicer:

A slicer

You can choose a region, but the slicer takes up loads of room in the report.

 

And here's the same slicer as a list:

Drop down list

You can click on the drop arrow to choose an item.

 

Here's what you see when you click on the drop arrow:

Expanded list

When you click on the drop arrow you see the full list of items.

 

The annoying thing about the way Microsoft have implemented this otherwise excellent feature is that you have to display the header name (which I'm used to hiding) - that's why there are two titles in my example (one being the title set separately, and the other being the header shown automatically).

This blog has 0 threads Add post