Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

New Member

Dynamic addition of a category in What-If analysis

Hi, I have a question regarding the dynamic addition of a category in What-If analysis.

Let’s say there is a company which currently has ‘Foods & Beverages’ data as one category with multiple SKUs in it. If they want to check how their profits will change by changing the fields, like variable cost, then we can easily do a what-if analysis for them.

But suppose they come up with a new category ‘Beauty & Health'. Now, is there any automatic way in which power bi can replicate all the work that we did for Food & Bev category for this new category? Can it automatically do what-if analysis on the same field (variable cost)?

Also, in what if analysis we can see only one result. Is there a way where we can create multiple result set so that we can compare them in parallel, like if we change the field by 10% then result will be XYZ and if by 20% then it will be ABC. Can I view them simultaneously?


Thanks in advance!

Community Support
Community Support

Hi @Aakash_Sethi ,


Can you provide sample data and expected results?


Best regards,
Community Support Team_ Scott Chang


Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors