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 in the last few months, see this blog.  Our two-day Power BI Desktop course always uses the latest version of the software.

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! 

This blog has 0 threads Add post