![\"Power](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi1.png\")
<\/p>\n
The Trend line<\/strong><\/h2>\nIf your data \u201cjumps\u201d up and down it can be difficult to see if you have a positive or negative trend, so here a trend line is handy.<\/p>\n
To add a trend line:<\/strong><\/p>\n\n- Select your visual<\/li>\n
- Click on the down arrow before the trend line option<\/li>\n
- Click add on the analytics pane<\/li>\n<\/ul>\n
The settings\/options will then appear and you will see the trend line on your visual.<\/p>\n
![\"Power](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi2.png\")
<\/p>\n
With all lines, you have the option to change the colour, style, and transparency. If you change the Combine Series option in the Trend Line setting to Off, it will display a trend line for each subcategory, which is useful for drilling down into the data.<\/p>\n
Combine series On:<\/strong><\/p>\n![\"Power](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi3.png\")
<\/p>\n
Combine series Off:<\/strong><\/p>\n![\"Power](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi4.png\")
<\/p>\n
The Constant line<\/strong><\/h2>\nA constant line can be very useful, for example if you have a target and you want to see at a glance if your values are below or above the target.<\/p>\n
![\"Power](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi5.png\")
<\/p>\n
To add a constant line:<\/strong><\/p>\n\n- Select your visual<\/li>\n
- Click on the down arrow before the constant line option<\/li>\n
- Click add on the analytics pane<\/li>\n
- Enter the value for the constant line<\/li>\n<\/ul>\n
The Min line<\/strong><\/h2>\nThe Min line will add a line showing the lowest value on the visual, and again you have the options to change the colour, style, and transparency.<\/p>\n
![\"Power](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi6.png\")
<\/p>\n
The Max line<\/strong><\/h2>\nThe Max line shows the highest value on the visual.<\/p>\n
![\"Power](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi7.png\")
<\/p>\n
The Average line<\/strong><\/h2>\nThe Average line shows the calculated mean average of all the values you have on the visual, which is great for showing the variation.<\/p>\n
![\"Power](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi8.png\")
<\/p>\n
The Median line<\/strong><\/h2>\nThe Median line will add a line showing the median of all the values you have on the visual.<\/p>\n
![\"Power](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi9.png\")
<\/p>\n
The Forecast line<\/strong><\/h2>\nThe Forecast line is very useful, especially if your data displays seasonality. Power BI is very good at handling complex levels of periodic seasonality, the only limitation is your date table. Fortunately, if you have week number, financial year, financial quarter, financial month, or other periodic breakdowns in your date table, they can all be used to visualise seasonality and forecast very accurately.<\/p>\n
![\"\"](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi10.png\")
<\/p>\n
Sometimes, you may look at your forecast and doubt how accurate it is. For example, in the visual above the forecast shows a decrease over the next 36 months, but this is wrong. The issue is that we haven\u2019t received all the data for the last three months, and this is having a negative effect on the forecast. Luckily, there is an easy way to fix this – you can ignore points!<\/p>\n
![\"Power](\"https:\/\/www.stl-training.co.uk\/b\/wp-content\/uploads\/2020\/06\/bi11.png\")
<\/p>\n
In the example above, 8 points (8 months) have been ignored. This not only takes care of the issue, but also allows you to see how close your forecast line fits your actual values. This will give you a clear indication of the forecast line\u2019s accuracy<\/p>\n
Also, the confidence level is set to 95% and the seasonality to Auto<\/em>. The confidence level is displayed on the visual by the grey area around the forecast line. Why Auto? This means if you change the visual, Power BI desktop automatically picks up the seasonality (4 if looking at quarters, 12 if looking at years).<\/p>\nConclusion<\/strong><\/h2>\nCreating insightful scenarios in Power BI can help you make powerful business decisions quickly. The Analytics Pane and the amazing tools inside it are just one small area of this incredible application.<\/p>\n
At STL we offer a range on Power BI training courses, for complete\u00a0beginners<\/a>\u00a0to\u00a0advanced<\/a>\u00a0users, so get in touch to find out more!<\/p>\n","protected":false},"excerpt":{"rendered":"With the Analytics Pane in Power BI, you can quickly and easily make dynamic reference lines, which can be extremely helpful when analysing data and making key business decisions. From simple trend lines to more complex forecast lines, there are so many options to choose from! First, find the analytics pane by going to the […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[650],"tags":[],"class_list":["post-5196","post","type-post","status-publish","format-standard","hentry","category-power-bi"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/5196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=5196"}],"version-history":[{"count":4,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/5196\/revisions"}],"predecessor-version":[{"id":5211,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/5196\/revisions\/5211"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=5196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=5196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=5196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- \n
- Select your visual<\/li>\n
- Click on the down arrow before the trend line option<\/li>\n
- Click add on the analytics pane<\/li>\n<\/ul>\n
The settings\/options will then appear and you will see the trend line on your visual.<\/p>\n
<\/p>\nWith all lines, you have the option to change the colour, style, and transparency. If you change the Combine Series option in the Trend Line setting to Off, it will display a trend line for each subcategory, which is useful for drilling down into the data.<\/p>\n
Combine series On:<\/strong><\/p>\n
<\/p>\nCombine series Off:<\/strong><\/p>\n
<\/p>\nThe Constant line<\/strong><\/h2>\n
A constant line can be very useful, for example if you have a target and you want to see at a glance if your values are below or above the target.<\/p>\n
<\/p>\nTo add a constant line:<\/strong><\/p>\n
- \n
- Select your visual<\/li>\n
- Click on the down arrow before the constant line option<\/li>\n
- Click add on the analytics pane<\/li>\n
- Enter the value for the constant line<\/li>\n<\/ul>\n
The Min line<\/strong><\/h2>\n
The Min line will add a line showing the lowest value on the visual, and again you have the options to change the colour, style, and transparency.<\/p>\n
<\/p>\nThe Max line<\/strong><\/h2>\n
The Max line shows the highest value on the visual.<\/p>\n
<\/p>\nThe Average line<\/strong><\/h2>\n
The Average line shows the calculated mean average of all the values you have on the visual, which is great for showing the variation.<\/p>\n
<\/p>\nThe Median line<\/strong><\/h2>\n
The Median line will add a line showing the median of all the values you have on the visual.<\/p>\n
<\/p>\nThe Forecast line<\/strong><\/h2>\n
The Forecast line is very useful, especially if your data displays seasonality. Power BI is very good at handling complex levels of periodic seasonality, the only limitation is your date table. Fortunately, if you have week number, financial year, financial quarter, financial month, or other periodic breakdowns in your date table, they can all be used to visualise seasonality and forecast very accurately.<\/p>\n
<\/p>\nSometimes, you may look at your forecast and doubt how accurate it is. For example, in the visual above the forecast shows a decrease over the next 36 months, but this is wrong. The issue is that we haven\u2019t received all the data for the last three months, and this is having a negative effect on the forecast. Luckily, there is an easy way to fix this – you can ignore points!<\/p>\n
<\/p>\nIn the example above, 8 points (8 months) have been ignored. This not only takes care of the issue, but also allows you to see how close your forecast line fits your actual values. This will give you a clear indication of the forecast line\u2019s accuracy<\/p>\n
Also, the confidence level is set to 95% and the seasonality to Auto<\/em>. The confidence level is displayed on the visual by the grey area around the forecast line. Why Auto? This means if you change the visual, Power BI desktop automatically picks up the seasonality (4 if looking at quarters, 12 if looking at years).<\/p>\n
Conclusion<\/strong><\/h2>\n
Creating insightful scenarios in Power BI can help you make powerful business decisions quickly. The Analytics Pane and the amazing tools inside it are just one small area of this incredible application.<\/p>\n
At STL we offer a range on Power BI training courses, for complete\u00a0beginners<\/a>\u00a0to\u00a0advanced<\/a>\u00a0users, so get in touch to find out more!<\/p>\n","protected":false},"excerpt":{"rendered":"
With the Analytics Pane in Power BI, you can quickly and easily make dynamic reference lines, which can be extremely helpful when analysing data and making key business decisions. From simple trend lines to more complex forecast lines, there are so many options to choose from! First, find the analytics pane by going to the […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[650],"tags":[],"class_list":["post-5196","post","type-post","status-publish","format-standard","hentry","category-power-bi"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/5196","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=5196"}],"version-history":[{"count":4,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/5196\/revisions"}],"predecessor-version":[{"id":5211,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/5196\/revisions\/5211"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=5196"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=5196"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=5196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}