The main new features for BI workers in the November 2016 Power BI update
Part seven of a seven-part series of blogs

A summary of the new features in the November 2016 Power BI Update, omitting things which are still only in preview.

  1. Power BI Desktop - November 2016 update
  2. Dropdown slicers - the new list option
  3. Conditional formatting now available for matrices
  4. Formatting table and matrix columns
  5. Changing the colour of axis titles and labels
  6. Prevent hierarchy axis label concatenation
  7. Forecasting now extended to Power BI Service (this blog)

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.

Forecasting now extended to Power BI Service

You've been able to show percentile lines, trend lines and forecasts for a while in Power BI Desktop, but you can now do this in Power BI Service too.

Quantity forecast

This chart shows a maximum and minimum line, plus a forecast.

To use this feature, create a chart (it works best with line charts):

A line chart

A line chart, waiting to be embellished.

Click on the Analytics icon, and choose what you want to do:

The choices available

The options are fairly self-descriptive.

 

For example, you could create a trend line:

Trend line Trend line chart
Analysis options The resulting trend line

The forecast shown at the top of this page came from the following choice of options:

Forecast options

These options would project a forecast 10 years into the future, showing a 95% confidence limit. Statistically this is a bit iffy - it assumes that the past is a guide to the future, which so often is not the case in life.

 

What would be really nice is a moving average trend line, like in Excel ...

This blog has 0 threads Add post