Burndown with Planned and Actual dates

[abid93]

Hi,

I need some help in producing a burndown graph in PBI. I have a dataset with an id, a planned completion date and an actual completion date that is filled in when a project is completed. I need a line graph to start at the earliest date showing the total number of projects and then gradually reducing to 0 at the final date for planned dates. For the actual dates it will start with the total count and then gradually reduce as and when the dates are populated (eventually to 0) 

I refered to this post which gets me very close to a solution but this works assuming all data values are populated which in my case they are not. 

I'm fairly new to PBI so any help is appreciated, i have included example data and a rough image of what chart im trying to achieve. 

ID	Planned Date	Actual Date
1	20/3/24	20/3/24
2	20/3/24	21/3/24
3	22/3/24	21/3/24
4	25/3/24
5	26/3/24
6	26/3/24
7	27/3/24
8	27/3/24
9	28/3/24

[Anonymous · Accepted solution]

Hi @abid93 ,

Please refer to my pbix file.

Create 2 measures.

Actual =
VAR _count =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Actual Date] >= MAX ( 'Table'[Planned Date] )
        )
    ) + 0
RETURN
    IF ( ISBLANK ( SELECTEDVALUE ( 'Table'[Actual Date] ) ), BLANK (), _count )

Planned =
VAR _count =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Planned Date] >= MAX ( 'Table'[Planned Date] )
        )
    ) + 0
RETURN
    IF ( ISBLANK ( SELECTEDVALUE ( 'Table'[Planned date] ) ), BLANK (), _count )

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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