Power BI Desktop - January 2017 update
Part two of a five-part series of blogs

A summary of the (small) changes in Microsoft's January 2017 Power BI Desktop update.

  1. Power BI Desktop - January 2017 update
  2. Word Wrap in Column Headings (this blog)
  3. Conditional Formatting of Blank Values in a Matrix or Table
  4. Summarising to show earliest/latest dates, or first/last text
  5. Creating Phone Optimised Reports

You can see a list of all updates going back to November 2016 here.

Posted by Andy Brown on 08 February 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.

Word Wrap in Column Headings

OK, this change isn't going to alter your life!  Suppose you have a table like this:

Widening column

You want to make the first column narrower.

 

Here's what happens by default:

Losing column header

You gradually lose the column header as you make the column narrower.  The solution used to be to use shorter headings!

 

You can now set the Word wrap property for column headings:

Word wrap property

Turn this property on to wrap column headings, where they don't fit into the available space.

 

Better?

Wrapped headings

Power BI Desktop will now insert breaks where there's a space or hyphen, if the column header doesn't fit onto a single row.

 

Apparently the ability to wrap text in data rows is coming very soon ...

This blog has 0 threads Add post