Forum Discussion
Burndown chart with parameters
Super UserHi Krlos5411 ,
You already have two parameters for total tool and weekly tool. Make another numeric parameter as week numbers to plot X axis. Then follow below image to achive this dynamic plotting.
Thanks!
Can you help me polishing my formula?
Total should be 50 as that is the toal set in the parameter, not 225.
The total should be 50 as is set in the parameter, then the weekly tools as 5, determine that the 50 tools with 5 tools by week, should require 10 weeks to do it (variable x axis).
And the both last values are 0.
Also, how can I add a new value as the actual development? The measure is an actual count of tools. I just drag it to it?
- Rupak_bi
Hi Krlos5411 ,
225 cannot come. Something you are missing. Try to diagnose step by step.
1. Check output of the total tool and weekly tool individually by modifying the MAXX expression. I am sure you will get the bug.
2. To add actuals, make sure, the table consisting actual data, must have a week no column. Make a relationship between the week table to the fact table on week nos. Then you can drag the actual column or measure.
If stucked, share pbix or sample data of fact table.