WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 479 reviews for our classroom and online training
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

For a cumulative list of all of the updates to Power BI Desktop since November 2016 see this blog, or have a look at the Power BI courses that we run.

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