Forum Discussion

manojk_pbi's avatar
manojk_pbi
Icon for Helper V rankHelper V
2 years ago
Solved

Add trend line along with MoM data

Hi Friends,   I am looking for suggestion on one of my requirement, please help me.  Requirement is to draw a chart with Month on Month trends of Open Bugs and a trend to show burndown of the bugs...
Need Help
manojk_pbi's avatar
manojk_pbi
Icon for Helper V rankHelper V
2 years ago

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

MYProductBugs#Bugs @10%
Jan-23Product11200 
Feb-23Product111001080
Mar-23Product11050972
Apr-23Product11025875
May-23Product1950787
Jun-23Product1940709
Jul-23Product11000638
Aug-23Product1900574
Sep-23Product1850517
Oct-23Product1880465
Nov-23Product1800418
Dec-23Product1700377
Jan-24Product1650 
Feb-24Product1600585
Mar-24Product1580527
Apr-24Product1590521
May-24Product1 516
Jun-24Product1 511
Jul-24Product1 506
Aug-24Product1 501
Sep-24Product1 496
Oct-24Product1 491
Nov-24Product1 486
Dec-24Product1 481

 

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

 

see attached