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
Can u add a series of text values and in a table or matrix allow the user to add select the field not contained in the data source to each rows of table or matrix
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...
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
@@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?
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?
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?
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.
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.
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.
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.
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?
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 ?
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?
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.
Is it possible to make different % for each month/quarter? E.g January will grow 1%, February 0.5% etc
Thanks!
Hey Hakan! Thanks a lot for your support :)
Excellent explanation of all the Power BI videos. Well Done!! Please keep posting these kind of videos regularly / more often
Thanks, will do! 🙂
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??
This really helped me in my job !!!
Thanksss a ton ❤️
so nice to hear! awesome! 👊😀😎
Can u add a series of text values and in a table or matrix allow the user to add select the field not contained in the data source to each rows of table or matrix
Bas, Is there a way to extend the forecast beyond the 2021 in the forecast measure? if so, how?
Great video for getting started with What-If Analysis! Thank for sharing Bas🔥
thanks so much! 😃
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...
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 😉
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
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?
Awsome.. u r master of Power BI
haha too much credit 😊 thank you so much
great video, concise and accurate.
Thanks a lot. It's an excellent video. I really help me a lot
Happy to hear this!
Very well explained. Can u please help by sharing data sets?
Thank you 😃 there is a download link in the description.
Can you default the slider to a specific % and have that default there every time you leave the page?
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?
Thnx Bas! I enjoy your well explained videos!
so nice to hear! 😀 thanks for watching!
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.
Very useful Bas, thanks! Is it possible to make different % for each month/quarter? E.g January will grow 1%, February 0.5% etc
Hi, thaks a lot, can you tell me how can I upload the file please ?
nice video. When you showed the three sliding scales at 9:26, is there a way to combine it into one?
One more subscriber! this was really helpful.
Very well explained. Good work. 👍
Thanks a lot 😊
Fantastic presentation.
thanks! 😃
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.
is this possible if i only have Sept 2022 - May 4 2023 data?
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.
Very well done! Keet it up!
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.
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
Award for best smile goes to🎉
What if the year column has character in it? For example FY2021 instead of 2021?
Thnaks, excellent video!!
awesome, thanks! 😃
Excellent video bro!
Appreciate it!👊
Amazing video, thank you!
Glad you liked it, Thx for watching! 😀
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?
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.
Legendary!
amazing"!!!!
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?
I can't try this. It is so error on my PBI. someone help to me.
@how to power BI
Great video! Could you explain more about what you put in the base measures, not just the general data table?
This too fuckin comlicated!!!!!