WHAT-IF analysis means the study of how model output varies with changes in input.
Below are the simple steps, by using which you can create a Dashboard using WHAT-IF Analysis:-
1) First you have drag below component to Canvas:-
I) A Bar Chart
ii) A Pie Chart
iii) A Gauge
iv) A Panel Container which consists more than one Horizontal Slider
2) Come to Spreadsheet:-
3) Properties of Bar Chart:-
4) Properties of Pie Chart:-
5) Properties of Horizontal slider:-
6) Properties of Gauge:-
7) After execution before changing WHATIF Analysis:-
8) After changing vale of Pencil, the overall values are changes. Follow the Screenshot:
9) After changing all the values of Horizontal slider (Pencil/Pen/Bags/Books), follow the changes which shown in the below screenshot:-
Hope this helps….