WHAT IF PARAMETERS in Power BI I Forecasting Power BI Search Trends in 2021

Learn how to use what if parameters in Power BI to perform what if scenario analysis. In this video I walk you through an example in which I apply what if parameters to a forecast for Power BI search trends. You will see how Power BI search trends compare to Tableau and Qlik based on data from google trends. If you like to play around with the example file see the download link below. Enjoy learning about What If parameters in Power BI!

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
0:00 Intro
0:43 Example for what if parameters - Power BI Search Trends
2:43 Creating a forecast and showing it in a line chart
5:48 Creating what if parameters
7:28 Using what if parameters in measures
8:30 UX of what if parameter slicers
9:18 Creating reference points for what if parameters
11:44 Forecasting Power BI Search Trend for 2021 using what if parameters
12:40 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!

Thanks for being a part of this channel and all your support! 💪 🙏

#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[Jordan-dovt]

Is it possible to make different % for each month/quarter? E.g January will grow 1%, February 0.5% etc

[nikhil]

Excellent explanation of all the Power BI videos. Well Done!! Please keep posting these kind of videos regularly / more often

[gaganpreetsinghrajpal]

Your videos are super useful, Bas! Thanks for keeping them concise and explaining so well

[MrRohanroxx]

This really helped me in my job !!!
Thanksss a ton ❤️

[alicedwonderland]

My dude, your videos are so useful it's crazy! Why don't you have more subscribers??

[kishore_p]

Great video for getting started with What-If Analysis! Thank for sharing Bas🔥

[Theozzie]

Can you default the slider to a specific % and have that default there every time you leave the page?

[sukoi]

Power BI magic.. Bring it on. You are a damn magician.

[YaElDaniels]

Hi, thank you, excellent video! I have a question, is it possible to put the reference points you created as value by default on the what if parameter slicer? or even put it as limit in the genereteseries formula? thanks in advance!! again great video

[deepakgautam]

For instance: We are tasked with developing a forecasting system for the Sales department, where adjustments to sales prices are required based on user-defined factors such as interest rates (6%) and inflation rates (3%). These factors have associated weightings, interest rates (10) and inflation rates (5), and users should be able to input values between -1 and 1 for each factor and additionally, we need to calculate the average of these values as the Net adjustment. Where after Net Adjustment is calculated.

Once the adjustment is determined, we want to incorporate it into a what-if analysis for forecasting. How can we effectively implement this in the what-if parameters, considering the user-inputted values, weightings, and the calculation of the Net adjustment?

Dax measures is we can do but we can't do hard code those values mean we need to check what if parameters using multiple categories.

[louizaamalou]

Hi, thaks a lot, can you tell me how can I upload the file please ?

[viniciusnaegele]

Very useful Bas, thanks! Is it possible to make different % for each month/quarter? E.g January will grow 1%, February 0.5% etc

[jrgenskevik]

Hi, very nice video!
Quick question, I want to change the visual to not show the same period next year but the next 12 months. I can't get it to wotk, do you have any idea?

[screaminbrod]

is this possible if i only have Sept 2022 - May 4 2023 data?

[Ravi-ceth]

sir, I stuck in between - you did forecast for 2021 u used year(max(dim date[date])) = 2021 but what if in need to start from specific date 26/9/2021 today(data available up to today, we need to forecast for next 1 year) how can we do it, sir?

[abhi]

What if the year column has character in it? For example FY2021 instead of 2021?

[Alan.DL]

Great piece! In the downloadable file measures are slightly different and the forecast lines are not connected. I can't find a way to solve it, would you help please?

[sirajuddinmohammed]

Thanks for video and I am able to replicate for one year. I am trying to do what if for multiple year forecasting based on the previous year.( for example: I have sales value from 2018 - 2020 and I need to forecast from 2021 - 2025 based on what if parameter). Any help is much appreciated.

[sowmiyajaganathan]

This is first time coming to your channel... And This is 3rd video that I'm watching about 'What-if Parameters'... But ufff... I can't able to listen to your content, you're so handsome man!! I like your hair style...

[bhuruu]

Hi .. nice illustration. What if we need to have only 1 What if Parameter for all 3 metrics/measures ? I mean single slicer to choose Forecast % for all three measures.
I'm stuck in this scenario.