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 (this blog)
- Formatting table and matrix columns
- 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.
Conditional formatting now available for matrices
You could already do this for tables, but now it works for matrices too:
Here I've coloured the matrix cells according to the total quantity shown in each.
To get this to work, click on the drop arrow next to the Values field in the field well:
Here we're showing the total quantity for each row/column combination, so click on the arrow to the right of Quantity and choose to change its conditional formatting.
You can now set the formatting you want to use:
Tick the Diverging box shown above to include an additional colour for the middle value.
A welcome new feature!
- Power BI Desktop - November 2016 update
- Dropdown slicers - the new list option
- Conditional formatting now available for matrices (this blog)
- Formatting table and matrix columns
- Changing the colour of axis titles and labels
- Prevent hierarchy axis label concatenation
- Forecasting now extended to Power BI Service