Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
Solved! Go to 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.
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.
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |