WHAT IF PARAMETERS in Power BI I Forecasting Power BI Search Trends in 2021
Vložit
- čas přidán 30. 07. 2024
- 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!
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ 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 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on CZcams: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* 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 - Věda a technologie
Tableau or Power BI?
My response to this age old question: depends on context or bias & what works best for the individual. I’ve been exposed to Microsoft productivity tools for the onset, started using Tableau when it first came out but had challenges working with both for data analysis. So when Power BI eventually came along (started with power query / pivot), it was a natural fit ever since. As such, I say Power BI as a preference & one who has used both for his particular context 😀
I would choose Power BI for 2 main reasons
1. Works well with Microsoft suite of apps
2. Power BI has been bringing in really good features under the hood lately
Power BI . Microsoft Ecosystem it work well with Power Apps and other services.
Power BI is awesome, so I'm not interested in exploring Tableau.
Your videos are super useful, Bas! Thanks for keeping them concise and explaining so well
:) glad you enjoy the videos! Thanks for watching and the comment
My dude, your videos are so useful it's crazy! Why don't you have more subscribers??
Excellent explanation of all the Power BI videos. Well Done!! Please keep posting these kind of videos regularly / more often
Thanks, will do! 🙂
Great video for getting started with What-If Analysis! Thank for sharing Bas🔥
thanks so much! 😃
One more subscriber! this was really helpful.
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
This really helped me in my job !!!
Thanksss a ton ❤️
so nice to hear! awesome! 👊😀😎
Thnx Bas! I enjoy your well explained videos!
so nice to hear! 😀 thanks for watching!
great video, concise and accurate.
Very well done! Keet it up!
Amazing video, thank you!
Glad you liked it, Thx for watching! 😀
Very useful Bas, thanks! Is it possible to make different % for each month/quarter? E.g January will grow 1%, February 0.5% etc
nice video. When you showed the three sliding scales at 9:26, is there a way to combine it into one?
Power BI magic.. Bring it on. You are a damn magician.
😂 haha too much credit, hope you know how to do the tricks yourselve though after watchn it 😉
Thnaks, excellent video!!
awesome, thanks! 😃
Thanks a lot. It's an excellent video. I really help me a lot
Happy to hear this!
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?
Very well explained. Good work. 👍
Thanks a lot 😊
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.
amazing"!!!!
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.
Legendary!
Awsome.. u r master of Power BI
haha too much credit 😊 thank you so much
Excellent video bro!
Appreciate it!👊
Fantastic presentation.
thanks! 😃
Excellent video. Thank you very much.
Glad you liked it!!! 😀
@@HowtoPowerBI Hi Bas, one question. The data I'm using is on a monthly basis, last 4 years. Up to mid-october. then Nov2021 and Dec 2021 have 0, instead of blanks. When using the line chart, the line drops to zero in the last two months. I used an if to avoid painting the line: IF([Sales]=0||ISBLANK([Sales]),Forecast, [Sales]) Does this seem ok? or would there be another better way to do it?
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...
Can you default the slider to a specific % and have that default there every time you leave the page?
Is it possible to make different % for each month/quarter? E.g January will grow 1%, February 0.5% etc
Great video! Could you explain more about what you put in the base measures, not just the general data table?
Thanks!
Hey Hakan! Thanks a lot for your support :)
What if the year column has character in it? For example FY2021 instead of 2021?
Award for best smile goes to🎉
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?
Very well explained. Can u please help by sharing data sets?
Thank you 😃 there is a download link in the description.
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.
Making a parameter with a large range (100 - 3000) and for some reason it isn't letting me select certain numbers (ex - I type in 1000, it returns 1001). I looked it up and it's a known issue, has anyone found a work-around?
is this possible if i only have Sept 2022 - May 4 2023 data?
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?
Thx for pointing out! I've attached the version that corresponds with the video.
This is really cool, But is there anyway whatever we enter in "%" we enter, can power BI remember the value and next time when we open the service, can we have this stored ?
only if you save it afterwards
@@HowtoPowerBI
How to save that afterwards?
@@vjnvinod save the what if slicer setting as a bookmark and 'set as default'. Then it'll show every time you open Power BI in the Service.
Bro,, how we can get region wise data from google trends? pl tell me
go to google trends: trends.google.com/trends/explore?q=power%20bi&geo=US and then you can click on the dropdown for the country. So I did it one by one (country by country), I don't think you can select multiple regions at once.
thanks
I can't try this. It is so error on my PBI. someone help to me.
@how to power BI
This too fuckin comlicated!!!!!