Forum Discussion
Helper ISpecific What if scenario comparison
Hi All,
I have a table of Clothing sales listed below. I'm trying to create a what if scenario in which I change a spcific value in the small medium and large columns and see how it compares with the original amount.
For example, I currently have 84 Total items sold. I want to be able show what it would look like for the total amount if the Small America Sweaters were lowered by 1 or more. I would want to be able to do it for any of the options listed below. How would the total change if I lowered the amount of Peru Tshirts by 3? Is there a slicer, Parameter, or formula that can do this?
| Continent | Country | Style | Small | Medium | Large |
| NA | America | TShirt | 1 | 1 | 1 |
| NA | America | Sweater | 2 | 2 | 2 |
| NA | Cananda | TShirt | 3 | 3 | 3 |
| NA | Mexico | TShirt | 4 | 4 | 4 |
| SA | Brazil | Sweater | 5 | 5 | 5 |
| SA | Peru | TShirt | 6 | 6 | 6 |
| SA | Peru | Sweater | 7 | 7 | 7 |
Thanks for your help on this!
2 Replies
- parry2k
Super User
MoonAlligator have you looked at what-if parameters? Use parameters to visualize variables - Power BI | Microsoft Learn
Hi MoonAlligator ,
--I want to be able show what it would look like for the total amount if the Small America Sweaters were lowered by 1 or more.
--Based on the example you gave, 6*3=18 what-if parameters would need to be created, which would be very unattractive.You can submit feedback to Microsoft requesting a more flexible what-if parameter feature.
Welcome to Microsoft Fabric Ideas
Users and similar ideas:
Single Value What-If Parameter ValueBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
