Forum Discussion
Add trend line along with MoM data
See attached. I made your burndown goal flexible.
Please provide sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.
HI lbendlin ,
Here i am attaching complete set of sample data and the required out put. Please suggest how the existing measure can be modiy to get the required output.
I would need filter on Year and Product. On all filter the data should work and provide burndown trend.
Sample Data
| MY | Product | Bugs# | Bugs @10% |
| Jan-23 | Product1 | 1200 | |
| Feb-23 | Product1 | 1100 | 1080 |
| Mar-23 | Product1 | 1050 | 972 |
| Apr-23 | Product1 | 1025 | 875 |
| May-23 | Product1 | 950 | 787 |
| Jun-23 | Product1 | 940 | 709 |
| Jul-23 | Product1 | 1000 | 638 |
| Aug-23 | Product1 | 900 | 574 |
| Sep-23 | Product1 | 850 | 517 |
| Oct-23 | Product1 | 880 | 465 |
| Nov-23 | Product1 | 800 | 418 |
| Dec-23 | Product1 | 700 | 377 |
| Jan-24 | Product1 | 650 | |
| Feb-24 | Product1 | 600 | 585 |
| Mar-24 | Product1 | 580 | 527 |
| Apr-24 | Product1 | 590 | 521 |
| May-24 | Product1 | 516 | |
| Jun-24 | Product1 | 511 | |
| Jul-24 | Product1 | 506 | |
| Aug-24 | Product1 | 501 | |
| Sep-24 | Product1 | 496 | |
| Oct-24 | Product1 | 491 | |
| Nov-24 | Product1 | 486 | |
| Dec-24 | Product1 | 481 |
see attached
Hi lbendlin , thanks for you quick response.
I think my question was not clear as i didn't mention few points clearly, sorry for that.
In the above table Bugs@10% column is created by me to draw a output in excel to post for this question. In reality, that column not exist so the dates from may'24 to dec'24 not available in the table. 1st Question is how to populate these dates to draw complete year chart and 2nd part is how can i make the year selection as filter and create chart accordingly.
Your data model must contain a Calendar table. Use the dates from there. Add the year filter from there as well.