Forum Discussion

mathias1998's avatar
mathias1998
Frequent Visitor
3 years ago

Burndown chart - dates and approvals?

Hi,

 

I have a data set where I want to make a burndown chart.

 

X-axis: Dates.

Y-axis: Remaining approvals.

Line 1: Approval Planned

Line 2: Approval Actual

 

So far, I have the following relevant columns: 

 

- ID, these are the units which can be approved.

- Approval Planned, consists of date values (e.g., 30.12.2022 if the approval is planned for 30.12.2022)

- Approval Actual, consits of date values (e.g., 10.10.2022, if it was actually approved on 10.10.2022). Note that cells are blank until if they have not been approved yet.

- I also have calculated a column called Approval Remaining, though I am not sure it is relevant in a burn down chart. It consists of the value 1 for cells that contain a date in the Approval Actual and the value 0 for cells that contain no date (i.e. are blank) in Approval Actual.

 

Any helpful tips here would be highly appreciated! 😁

 

 

UPDATE: While waiting for answers, I tried to make a new calenedar table and made a *:1 relationship between the calendar table's date column and the ID column in my other table (connecting the Approval Date to the calendar table did not work because of cardinality). Afterwards, I made a new column = RELATED('OtherTable'[Approval Planned]) to insert a column that would contain the dates which are planned (e.g. 24.08.2022 would show up in the new column next to the 24.08.2022 row in the Date column). I get no errors, but all of the cells in the new column are empty. Hence, I am not any closer to a solution...

Burndown
Date
DAX
Visual

2 Replies

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, mathias1998 

     

    Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • mathias1998's avatar
      mathias1998
      Frequent Visitor
      3 years ago

      Hi v-zhangti , 

       

      I have the following relevant columns.

       

      Which may only consist of dates. 

       

      However, I also have a status column which may be helpful (filtered to show more values): 

       

       

      Based on the Status column, I have made two additional columns. The first one is: 

       

      Approved by Status as number =
      SWITCH([Status],"0-Not Started",0,"1-Deliverable Defined",1,"2-Draft",2,"3-Draft in Review",3,"4-Review for Approval",4,"4-Approved",5)
       
      The seocnd is: 
      Status not approved = IF('Deliverable Tracker'[Status]="4-Approved",0,1) 

       

      Attached image for context: 

       

       

      It might make sense to make the burn down chart using the Status not approved column as the "actual approval status" line, but I would still need to use the Approval Planned column to set the "planned approval" line. 

       

      Finally, the expected result will hopefully look something like this: