BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
A summary of the new features in the November 2016 Power BI Update, omitting things which are still only in preview.
- Power BI Desktop - November 2016 update
- Dropdown slicers - the new list option
- Conditional formatting now available for matrices
- Formatting table and matrix columns (this blog)
- Changing the colour of axis titles and labels
- Prevent hierarchy axis label concatenation
- Forecasting now extended to Power BI Service
You can see a list of all updates going back to November 2016 (this update) here.
Posted by Andy Brown on 19 December 2016
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.
Formatting table and matrix columns
This feature allows you to colour table and matrix columns. Below are a couple of examples (the feature is more powerful for tables than it is for matrices).
Example of formatting table columns
Each of the 3 columns in the following ugly table has different column formatting settings:

An example of how you can use column formats to ruin a table!
Here are the settings I used for the Quantity column:

For the Quantity column, I've chosen to use the colours for the header, values and total rows.
Formatting columns in a matrix
For a matrix, there are fewer options:

Here I've chosen not to format the values (otherwise nearly everything would appear with a purple background).
The settings I've used for the Column Formatting section of this matrix are:

Only the totals are coloured.
In case you're wondering, conditional formatting colours override column formatting colours!
- Power BI Desktop - November 2016 update
- Dropdown slicers - the new list option
- Conditional formatting now available for matrices
- Formatting table and matrix columns (this blog)
- Changing the colour of axis titles and labels
- Prevent hierarchy axis label concatenation
- Forecasting now extended to Power BI Service