This is the best explanation of What If parameters I have ever seen. Very simple but very comprehensive. Thanks bro. You made my day.

Thank you, Patrick. Your videos are nicely done and polished. Just starting out with PBI and I keep coming back to learn more.

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!!!!

Geez you guys are awesome!!!!! You made this sooo easy to understand. LOVE YOU SO MUCH.

Terrific ! I am a fan of you guys and also a Power BI developer . It's fun to see you guys share the knowledge

Thanks Patrick, awesome way to forecast!

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.

Great quick tips for designing Data Analytics courses. Thank you

Good walkthrough of What if parameters Patrick. It's perfect for adjusting budget and forecast scenarios

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

great video ( as always). how was your klm business class flight? ;)

Again and again just great!!!

Beautifully explained

Great Patrick.Thank you !! Is there a way to use separate what if parameters in every single month ...? Like having 12 slicers..??

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

Excellent tutorial

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!

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 Patrik!!

Now that was cool! Love it and super useful! Thanks a lot. Pace was just right!

Thanks for this super clear video. You are the best :)

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.

Love the power beer mug

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,

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!!

Great functionality & gud explanation as always:)

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

Thank You! Brilliant!

thank you! by the way, what kind of screen capture software are you using?

Where did you bought that cool Power Beer mug in the background?

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.

Thanks for showing that. Is it possible to filter the data based on that slicer?

Thanks

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. 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

Beautiful

Brilliant!

Awesome

Thanks. Can this work on decomposition tree . Please show us how

Mesmerizing!! this is bananas !!

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)?

Great video blending data forecast with whatif analysis👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻

Hey Patrick, can I use a parameter with an IF statement instead of what if scenario? Thanks

Patrick thanks for the tip!

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

Hi, I was wondering: there is a way we can use this to compare the first n days from each month?

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.

How do you make the extra bit from the parameter a different colour on the bar chat?

Hi patric, how can we put a sum wrap over average value of category ...please help

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?

can I also use the parameter in a calculated column?

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

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

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.

Thank you ^_^.

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! 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?

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

What if and a custom calendar selection? ... is that something you did a video on yet...

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%.

When I remove total sales column from the table at the end, does the table just turn into one row? Im having that issue : (

Can this be done in reverse ?

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.

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.

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 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.

Does using over 20 parameters can cause performance issues for PBI report?

Hello sir, can I use this as date parameter in my ageing report??? Pls help

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.

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 !!!