Forum Discussion

thegreenoz's avatar
thegreenoz
Frequent Visitor
1 year ago

Running Total Burndown

Hi folks, I am in need of help with a DAX problem I have been experiencing for over a week.   Problem Statement I want to create a power-bi line-chart that is: A cumulative total, month-over-mon...
Need Help
kushanNa's avatar
kushanNa
Icon for Super User rankSuper User
1 year ago

Hi,

 

from the screenshot you have provided here are my thoughts about it

 

  1. A cumulative total, month-over-month. - your line seems to be correct because i can only see Feb and march in resolved column 
  2. Show all the months of the year even if we don't have any data for future months. - there are blank months so i can see you got that right as well
  3. For future months, don't show a flat line, don't show any line. Show only up until current month basically.- for this you will need to do the following 
    create a new dax calculated column in date table which it says if it part of this month or before 

 

 

NewColumn = IF([Date] <= EOMONTH(TODAY(), 0), "Yes", "No")
​

 

 

and filter the yes only (SS is a sample i tested not your data)

 

  • Filter for issues that have status of Done.
    you can simply drag and drop status column to filters and filter only done 

     

  • Start from target number (i.e 40) and burn down to zero. - i can see a burning down in your sample line chart , so i feel like you got that right as well 
thegreenoz's avatar
thegreenoz
Frequent Visitor
1 year ago

Thanks I have added that. The one thing missing in my chart is that it should start at 40 and count downward. So I tried the following but getting a V-shaped chart.