{"id":3891,"date":"2021-12-31T18:41:03","date_gmt":"2022-01-01T02:41:03","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3891"},"modified":"2021-12-31T18:41:04","modified_gmt":"2022-01-01T02:41:04","slug":"how-to-do-a-forecasting-in-power-bi","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3891","title":{"rendered":"How to Do a Forecasting in Power BI"},"content":{"rendered":"\n

We now see a line graph like the one below. Head over the Visualization panel and under the list of icons, find the analytics icon as shown below.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Scroll down the panel and find the \u201cForecast\u201d section. Click on the down arrow to expand it if necessary.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Next, click on \u201c+Add\u201d to add forecasting on the current visualization.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

We\u2019ll now see a solid gray fill area and a line plot to the right of the visualization like the one below.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Let\u2019s change the Forecast length to 31 points. In this case, a data point equals a day so 31 would roughly equate to a month\u2019s worth of predictions. Click on \u201cApply\u201d on the lower right-corner of the Forecast group to apply the changes.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Instead of points, let\u2019s change the unit of measure to \u201cMonths\u201d instead as shown below.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Once we click \u201cApply,\u201d we\u2019ll see the changes in the visualization. The graph below contains a forecast for 3 months.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

What if we wanted to compare how the forecast compares to actual data? We can do this with the \u201cIgnore last\u201d setting.<\/p>\n\n\n\n

For this example, let\u2019s ignore the last 3 months of the data. Power Bi will then forecast 3 months’ worth of data using the dataset but ignoring the last 3 months. This way, we can compare the Power BI\u2019s forecasting result with the actual data in the last 3 months of the dataset.<\/p>\n\n\n\n

Let\u2019s click on \u201cApply\u201d when we\u2019re done changing the settings as shown below.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Below, we can see how the Power BI forecasting compares with the actual data. The black solid line represents the forecasting while the blue line represents the actual data.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

The solid gray fill on the forecasting represents the confidence interval. The higher its value, the large the area will be. Let\u2019s lower our confidence interval to 75% as shown below and see how it affects the graph.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

The solid gray fill became smaller as shown below.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Next, let\u2019s take into account seasonality. Below, let\u2019s set it to 90 points which is equivalent to about 3 months. Putting this value will tell Power BI to look for seasonality within a 3-month cycle. Play with this value with what makes sense according to the data.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

The result is shown below.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Let\u2019s return our confidence interval to the default value of 95% and scroll down the group to see formatting options.<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

Let\u2019s change the forecasting line to an orange color and let\u2019s make the gray fill disappear by changing formatting to \u201cNone.\u201d<\/p>\n\n\n\n

\"\"\/<\/figure>\n\n\n\n

And that\u2019s it! With a few simple clicks of the mouse, we got ourselves a forecast from the dataset.<\/p>\n\n\n\n

Ref: https:\/\/towardsdatascience.com\/forecasting-in-power-bi-4cc0b3568443<\/p>\n","protected":false},"excerpt":{"rendered":"

We now see a line graph like the one below. Head over the Visualization panel and under the list of icons, find the analytics icon as shown below. Scroll down the panel and find the \u201cForecast\u201d section. Click on the down arrow to expand it if necessary. Next, click on \u201c+Add\u201d to add forecasting on Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,621],"tags":[1022],"class_list":["post-3891","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-power-bi","tag-forecasting-in-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3891"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3891\/revisions"}],"predecessor-version":[{"id":3892,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3891\/revisions\/3892"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}