Power BI Desktop - January 2017 update
Part four 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
  3. Conditional Formatting of Blank Values in a Matrix or Table
  4. Summarising to show earliest/latest dates, or first/last text (this blog)
  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.

Summarising to show earliest/latest dates, or first/last text

This is probably the most useful change in this batch of updates.  You can now show for any category the first or last date of its entries:

Latest payment date

A table showing the latest payment date for each environment.

Here are the options for dates:

Latest aggregation

You can now choose to show the earliest or latest of all of the dates for a particular table or matrix cell.

 

You can use a similar technique (less usefully, perhaps) to show the first or last text entry for a table or matrix cell in alphabetical order:

Latest text entry

The latest shopping centre in the alphabet for each environment.

 

The option looks similar:

First and last

The options which appear for a text field.

 

I can't imagine this second option will get much use!

This blog has 0 threads Add post