WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 519 reviews for our classroom and online training
A summary of the new features of Power BI Desktop introduced in November 2017
Part four of a five-part series of blogs

There's not too much to whet the appetite here: most of the changes are extensions to existing features, such as conditional formatting and column-by-example.

  1. Power BI Desktop - November 2017 Update Highlights
  2. Adding Columns from Examples - Further Improvements
  3. Rules-based conditional formatting for tables and matrices
  4. Controlling Table and Matrix Cell Alignment (this blog)
  5. Locking objects to prevent moving/resizing them

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 15 November 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.

Controlling Table and Matrix Cell Alignment

OK, so this probably won't change your life, but every little helps.  You can set the horizontal alignment separately for column headers, field values and subtotals:

Alignment options

Here the Family title is centre aligned, but the values within the column are left-aligned. Similarly, the Quantity column is centre-aligned, with the exception of the subtotal which is right aligned.


You can set alignment options using the formatting palette:

Column header alignment Field header alignment
Column header options Field options

Note that you can specify a different alignment for each field (should you want to, which seems unlikely!).

The options above for displaying the quantity of sales used these choices:

Field formatting

The field is set to centre align, but these options won't apply to total rows.


I did say it wasn't a game-changer! 

Imagine being able to learn tips like this in a condensed form with an interactive course taught by a real Wise Owl!  You can see details of all of our online and classroom Power BI courses here.

This blog has 0 threads Add post