PowerBI: Create Burndown Chart
HI all, I am having trouble using measurements to create a dynamic calculated values for TotalHours, RemainingHours and TotalUserStoryPts so that I can create a burndown in PowerBI. Goal: Create a burndown chart using the following data: Sprint Start = 8/8/2022 Sprint End = 8/20/2022
Burndown Chart
Hi, I am trying to create a burndown graph for a list of software activities (user stories), which have 3 date fields: Baseline Completion Date - Assigned to all activities when they are created and serves as initial baseline schedule. Forecast Completion Date - Live view on when an activity will complete. Actual Completion Date - Self explanatory. A simple example dataset is shown below along with required chart output. In my dataset, I have the activity name then have ungrouped the 3 data fields differentiating through 'attribute' field. I have attempted to create the burndown graph as follows but the counts are not as expected; some records are missing and the counts jump.- My burndown measures are same for baseline/forecast/actual except for referring to different attributes. Please could someone advise how I can resolve this issue and best achieve the chart?
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...
