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 (this blog)
- Dropdown slicers - the new list option
- Conditional formatting now available for matrices
- 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.
Power BI Desktop - November 2016 update
The changes included in the update in this blog are:
| New feature | Notes |
|---|---|
| Drop down lists | The most welcome new feature, for me - you can now show slicers as a drop list. |
| Conditional formatting in matrices | Create heat maps by colouring cells according to the size of the values each contains. |
| Column formatting in tables and matrices | You can now set a different background colour for any column of a table! |
| Colour axis titles and labels | You can now set one colour for axis labels, and another for the axis title. |
| Prevent hierarchical axis label concatenation | A niche feature this - when you've drilled down in a chart using a hierarchy, you can prevent Power BI joining all the hierarchy level labels together. |
| Forecasting in Power BI Service | You can now create trendlines, percentiles and other useful lines not only in Power BI Desktop, but also in the web version of Power BI. |
Note that this blog doesn't cover any features which are still in preview (although the Microsoft blog does include these).
- Power BI Desktop - November 2016 update (this blog)
- Dropdown slicers - the new list option
- Conditional formatting now available for matrices
- 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