BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
A summary of the (small) changes in Microsoft's January 2017 Power BI Desktop update.
- Power BI Desktop - January 2017 update
- Word Wrap in Column Headings (this blog)
- Conditional Formatting of Blank Values in a Matrix or Table
- Summarising to show earliest/latest dates, or first/last text
- 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:
You want to make the first column narrower.
Here's what happens by default:
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:
Turn this property on to wrap column headings, where they don't fit into the available space.
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 ...