Comment: Today I had an extensive Power Bi session (trying to transition from Tableau since where I live Power Bi is more demanded than Tableau) and the Parameter bit had me worried because I couldn’t wrap my head around it, so I came across this video and I didn’t realize how simple this was to understand. Thank you!!!!
I used this in one of my Project. Made 2 What-if-parameters, whose values ranged from 1 to 100. Used them as filters, and made a clustered column chart where in I used those 2 values as constant lines. Those constant lines served for me as target values. And based upon the target value stored in a measure, what I did I created 2 different measures which stored colors, and conditionally formatted the values of the totals. Amazing explanation! Thank you @Guyinacube
Nice video! 3 comments about it: 1) What-if parameters are a neat feature for making fast sensitivity analysis (like, this will be the return depending on the price/cost/[select variable] of my product) 2) Using conditional formatting would help you in checking if the values get over your threshold. 3) I still don't know why this single-select slicers can't be created with any column of any table.
This is awesome man! soometimes we know functionalities are there but we dont know how to use them for business purpose. plz keep making these kind of videos.
I have been working on this for a bit, y9u can use 0 as the base and then increment by .1, just an option. Also, you can use the what if to see the impact on costs. Example you need to increase sales by 1.43% BUT my costs went up 6%, how much would we then need to make, its awesome!
Hi Patrick. Fantastic and clear instructions as always. I have a question and sorry for asking. I have created a measure that categorizes sales: not accomplished, accomplished, exceded. I use this measure in a table visual. Is there any way to filter the table by the measure values. "What if" may help? Thanks a lot and best regards Carlos
Great man, awesome video once again. One question, what if we want to give a discount to a given product and need to know how much we should sale including all our products to make it worth?
Vedio is very helpful ,thanks, How to read the what if parameter selected value in a different page. If we have a chart and selection control , it is working, but if the chart is in different page and selection is in different page.it is not working.
Hello ,Thanks it's an awesome feature. One question Is there a way we can hide the values in the what if parameter.I need to see only the slider of the what if parameter. Appreciate any help
is there a way that you can apply multiple 'what if' parameters with a button, rather than the output table repopulating after each parameter is changed?
Hi Patrick! Nice video! Is that possible to use a what-if parameter to send a subset of values from a main report to a drill through report? This subset of values are dynamic values (comes from a fact table). Thanks!!
Can I use what if parameter on a gantt chart visual? i.e I try to add 10 days on the start date of my project, then the chart will be updated to show the new schedule - starts day is 10 days later.
Hey Patrick, Great explanation. Quick question though? Is there a way to use this feature with Direct Query? Do you know if it is in the backlog? Regards,
Thanks. Great video. I would like to use What if parameters and link them to a filter. I have a Month and a Year column - I would like to use the single value slicer of the what if parameter to link that to a Year filter and month filter respectively. Is this possible?
Hi Patrick! I'm trying to use multiple parameters in different measures to create a forecasting/savings what if scenario. Do you have a topic on that one too? So the result of 4 selected (parameter filters) should show up in my table.
Is it possible to create 'what if parameter' for each of the month (individually)? i.e I would to forecast the sale for January to be 10%, but the rest of the months are going to be 50%.
Would it be possible to do a measure calculating automatically the exact threshold required to reach the desired point? Would look like 1,000,000=total sales x threshold (tbd) It would avoid manual computation, could give extra precision if needed and could be displayed directly as a percentage
Hi Patrick Is there any way in power Bi to define input fields(i.e Start date,end date and Id)When the report is published,allow the user to enter these values and then generate the report based on these input values?
Dear Sir, I want you to make a video on:- Like I have two slicers and one dynamic x-axis chart. In one of the slicers I have top n (5,10,15,20) and on the other slicer, I have customer and product. I have a dynamic x-axis chart showing sales by customers or product. So, when I select the customer and top 5 it will show in the dynamic chart or when I select top 20 and then select products it will show top 20 products by sales in the same dynamic x-axis chart. Please, sir, do a video on this.
Hey, I needed some help for my report. I want to find out my day on day growth %(Constant Value) if i know my starting value, my target value and number of days to achieve it. Mathematically it becomes a geometric progression where wew know the sum, first term and n. How do i find the common ratio r (%growth)?
Guys, is it possible to pass a parameter/variable to run a python script with a slicer in power BI? the idea is that users have an input parameter (Slicer) and that variable picked serves as a variable in a python script
Hi! do you know if it's possible to reset a What If parameter back to default? Once I publish the report and users start playing with the parameters, the default feature is basically inexistent?
Hello, Patrick, Thanks for the video, I have a doubt in creating a scatter plot Is it possible to set the axis measures dynamically, for eg I have huge list of Measures like Total sales, category sales,Subcategory sales , product sales, store sales all these measure titles are in slicer. So when the user select any two of these it will automatically set the axis value based on the selection. For instance, If the user select Category sales and store sales so X axis will be category sales and Y axis will be store sales and plot the chart based on the sames values. Please let me know is it possible to achieve in power bi Thanks in Advance
I would like the opposite. I want to decrease the value. I guess that I can use negative figures, correct? Also, we would need to divide instead of multiply. We want to see how hard collectors are going to need to work to bring down the high value of outstanding invoices.
could anyone please share a sample workbook for this? I get "Column 'Table - 1 Value' in table 'Table - 1' cannot be found or may not be used in this expression." error when I try to use the value of parameter.
Hi sir, I want to input text in power bi, we can say like a form. A user inputs some information in form of text .(Not using power apps) Can you please suggest if it is possible or not ? If possible please suggest a way.
This is the best explanation of What If parameters I have ever seen. Very simple but very comprehensive. Thanks bro. You made my day.
Awesome! 👊 Thanks for watching.
Comment:
Today I had an extensive Power Bi session (trying to transition from Tableau since where I live Power Bi is more demanded than Tableau) and the Parameter bit had me worried because I couldn’t wrap my head around it, so I came across this video and I didn’t realize how simple this was to understand.
Thank you!!!!
I used this in one of my Project.
Made 2 What-if-parameters, whose values ranged from 1 to 100. Used them as filters, and made a clustered column chart where in I used those 2 values as constant lines.
Those constant lines served for me as target values. And based upon the target value stored in a measure, what I did I created 2 different measures which stored colors, and conditionally formatted the values of the totals.
Amazing explanation!
Thank you @Guyinacube
Nice video! 3 comments about it:
1) What-if parameters are a neat feature for making fast sensitivity analysis (like, this will be the return depending on the price/cost/[select variable] of my product)
2) Using conditional formatting would help you in checking if the values get over your threshold.
3) I still don't know why this single-select slicers can't be created with any column of any table.
I m from argentina and im a big fan of yours videos, thaks for sharing, you are helping people from all over the world and making new jobs
Good walkthrough of What if parameters Patrick. It's perfect for adjusting budget and forecast scenarios
Agree
This is awesome man! soometimes we know functionalities are there but we dont know how to use them for business purpose. plz keep making these kind of videos.
Glad you found it useful. Thanks for watching. 👊
Thank you, Patrick. Your videos are nicely done and polished. Just starting out with PBI and I keep coming back to learn more.
Thanks. Can this work on decomposition tree . Please show us how
Geez you guys are awesome!!!!! You made this sooo easy to understand. LOVE YOU SO MUCH.
Beautifully explained
Why you always have the video that I need to see? Amazing Bro
Fantastic doing my budget and will use this as keep getting asked What If
I have been working on this for a bit, y9u can use 0 as the base and then increment by .1, just an option. Also, you can use the what if to see the impact on costs. Example you need to increase sales by 1.43% BUT my costs went up 6%, how much would we then need to make, its awesome!
Great quick tips for designing Data Analytics courses. Thank you
Thanks Patrick, awesome way to forecast!
Excellent tutorial
Terrific ! I am a fan of you guys and also a Power BI developer . It's fun to see you guys share the knowledge
Again and again just great!!!
Now that was cool! Love it and super useful! Thanks a lot. Pace was just right!
Appreciate that! Thanks for watching Erica! 👊
can I also use the parameter in a calculated column?
You can't. Calculated columns must be determined during processing/refreshing of the model.
@@MrPandrewski thanks for your response. I realised this after a few hours of posting this!
Great video blending data forecast with whatif analysis👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻
Thanks Abid! Appreciate that 👊
Love the power beer mug
Thanks
Thanks for this super clear video. You are the best :)
Patrick thanks for the tip!
Just for you Mark 😎👊
@@GuyInACube I heard you comment on this and love the flexibility this brings to reports. Much appreciated
Hi Patrick. Fantastic and clear instructions as always.
I have a question and sorry for asking. I have created a measure that categorizes sales: not accomplished, accomplished, exceded.
I use this measure in a table visual. Is there any way to filter the table by the measure values. "What if" may help?
Thanks a lot and best regards
Carlos
Great Patrick.Thank you !!
Is there a way to use separate what if parameters in every single month ...? Like having 12 slicers..??
What if and a custom calendar selection? ... is that something you did a video on yet...
Great functionality & gud explanation as always:)
You guys rock! Thank you so much!
Great man, awesome video once again. One question, what if we want to give a discount to a given product and need to know how much we should sale including all our products to make it worth?
great video ( as always). how was your klm business class flight? ;)
Thank You! Brilliant!
Welcome! 👊
Thanks for showing that. Is it possible to filter the data based on that slicer?
Beautiful
Vedio is very helpful ,thanks, How to read the what if parameter selected value in a different page.
If we have a chart and selection control , it is working, but if the chart is in different page and selection is in different page.it is not working.
Mesmerizing!! this is bananas !!
haha thanks Pratik! Appreciate that. 👊
Great Patrik!!
Hello ,Thanks it's an awesome feature. One question Is there a way we can hide the values in the what if parameter.I need to see only the slider of the what if parameter. Appreciate any help
Where did you bought that cool Power Beer mug in the background?
how can I fix the issue of giving me a blank value if I visualize the measure created from the numeric parameter table on a different page
is there a way that you can apply multiple 'what if' parameters with a button, rather than the output table repopulating after each parameter is changed?
Hi Patrick! Nice video! Is that possible to use a what-if parameter to send a subset of values from a main report to a drill through report? This subset of values are dynamic values (comes from a fact table). Thanks!!
Can I use what if parameter on a gantt chart visual? i.e I try to add 10 days on the start date of my project, then the chart will be updated to show the new schedule - starts day is 10 days later.
Hey Patrick,
Great explanation. Quick question though? Is there a way to use this feature with Direct Query? Do you know if it is in the backlog?
Regards,
Thanks. Great video. I would like to use What if parameters and link them to a filter. I have a Month and a Year column - I would like to use the single value slicer of the what if parameter to link that to a Year filter and month filter respectively. Is this possible?
How do you make the extra bit from the parameter a different colour on the bar chat?
Hi Patrick! I'm trying to use multiple parameters in different measures to create a forecasting/savings what if scenario. Do you have a topic on that one too? So the result of 4 selected (parameter filters) should show up in my table.
Is it possible to create 'what if parameter' for each of the month (individually)? i.e I would to forecast the sale for January to be 10%, but the rest of the months are going to be 50%.
Would it be possible to do a measure calculating automatically the exact threshold required to reach the desired point?
Would look like 1,000,000=total sales x threshold (tbd)
It would avoid manual computation, could give extra precision if needed and could be displayed directly as a percentage
Brilliant!
Thanks Brian! And, thanks for watching 👊
Hi patric, how can we put a sum wrap over average value of category ...please help
thank you! by the way, what kind of screen capture software are you using?
Awesome
Hi, I was wondering: there is a way we can use this to compare the first n days from each month?
Hey Patrick, can I use a parameter with an IF statement instead of what if scenario? Thanks
Hi Patrick
Is there any way in power Bi to define input fields(i.e Start date,end date and Id)When the report is published,allow the user to enter these values and then generate the report based on these input values?
Does using over 20 parameters can cause performance issues for PBI report?
As with all things - "It depends". Without more details, I would lean towards - yes?
Dear Sir,
I want you to make a video on:-
Like I have two slicers and one dynamic x-axis chart. In one of the slicers I have top n (5,10,15,20) and on the other slicer, I have customer and product. I have a dynamic x-axis chart showing sales by customers or product. So, when I select the customer and top 5 it will show in the dynamic chart or when I select top 20 and then select products it will show top 20 products by sales in the same dynamic x-axis chart.
Please, sir, do a video on this.
When I remove total sales column from the table at the end, does the table just turn into one row? Im having that issue : (
Hey, I needed some help for my report. I want to find out my day on day growth %(Constant Value) if i know my starting value, my target value and number of days to achieve it. Mathematically it becomes a geometric progression where wew know the sum, first term and n. How do i find the common ratio r (%growth)?
Guys, is it possible to pass a parameter/variable to run a python script with a slicer in power BI? the idea is that users have an input parameter (Slicer) and that variable picked serves as a variable in a python script
Hi! do you know if it's possible to reset a What If parameter back to default? Once I publish the report and users start playing with the parameters, the default feature is basically inexistent?
Hi Patrick I have question, while building a report can we create a link to navigate a ceratin dashboard
is that possible? can you please help me out
Hello, Patrick,
Thanks for the video,
I have a doubt in creating a scatter plot
Is it possible to set the axis measures dynamically,
for eg I have huge list of Measures like Total sales, category sales,Subcategory sales , product sales, store sales all these measure titles are in slicer. So when the user select any two of these it will automatically set the axis value based on the selection.
For instance, If the user select Category sales and store sales so X axis will be category sales and Y axis will be store sales and plot the chart based on the sames values.
Please let me know is it possible to achieve in power bi
Thanks in Advance
I would like the opposite. I want to decrease the value. I guess that I can use negative figures, correct? Also, we would need to divide instead of multiply. We want to see how hard collectors are going to need to work to bring down the high value of outstanding invoices.
could anyone please share a sample workbook for this? I get "Column 'Table - 1 Value' in table 'Table - 1' cannot be found or may not be used in this expression." error when I try to use the value of parameter.
Thank you ^_^.
Hi sir,
I want to input text in power bi, we can say like a form.
A user inputs some information in form of text .(Not using power apps)
Can you please suggest if it is possible or not ? If possible please suggest a way.
Can this be done in reverse ?
Hello sir, can I use this as date parameter in my ageing report???
Pls help
Patrick's actually working on a video for a "date picker" of sorts. That may end up working better for you than using the What If parameter.
@@GuyInACube Is there any solution to add date parameter for dynamic ageing by Tmrw coz I have to submit my report by Tmrw to my manager... Pls help
Nice one. But sales guys won't like this 😊
Hello sir, how to add date parameter in ageing report?
Pls help
Where the hell does the Total Sales value come from - there is an assumption here that is not explained !!!! Exasperating !!!