Can What If parameters help in Power BI reports?

Patrick looks at the What if parameters in Power BI Desktop to help you solve interesting questions in your Power BI reports.

********
LET'S CONNECT!
********

***Gear***

[luistrejo]

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

[SamirHabib]

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

[hendynv]

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

[vishaljhaveri]

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

[ruthlammers]

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

[MrAszpic]

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.

[KostasKrommidas-rr]

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

[AyushKarnwal]

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

[juanignacioXI]

Thanks Patrick, awesome way to forecast!

[fadams]

Great quick tips for designing Data Analytics courses. Thank you

[nancygeorge]

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

[MFlorenciaGross]

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

[luisacuna]

Why you always have the video that I need to see? Amazing Bro

[neilrobertson]

Fantastic doing my budget and will use this as keep getting asked What If

[shakeeljuggath]

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?

[nagasatyadevarakonda]

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,

[luisedugarridosoares]

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

[maanavdoshi]

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

[nataschalaros]

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.

[clifordakoyo]

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