Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
elly2212
Regular Visitor

Burndown Chart Help Needed with Measures

Hi, I am trying to build burndown chart visual for multipel projects with different Start and Completion date. Some sample data below. Can you please assist with measures in order to build a final Burndown Table with the Remaining values to use in visual? Thanks!! 

ProductProject StartTarget CompletionTotal InstancesCompletedAs Of
P19/1/20236/30/2024                 40,000                 10,00011/30/2023
P211/1/20236/30/2025                    5,000                    1,00011/30/2023
2 ACCEPTED SOLUTIONS
aj1973
Community Champion
Community Champion

Hi @elly2212 

check out this

https://community.fabric.microsoft.com/t5/Desktop/Burndown/m-p/1196014

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

View solution in original post

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1702181236364.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

8 REPLIES 8
Ashish_Mathur
Super User
Super User

Hi,

Please show the expected result in a simple Table format.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Targeting the yellow summary of this image: visual2.jpg

Hi,

Share the download link of the MS Excel file with the formulas already written there.  I will try to convert those Excel formulas into measures using DAX.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Please try this link: Example Excel 

Hi,

PBI file attached.

Hope this helps.

Ashish_Mathur_0-1702181236364.png

 


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
elly2212
Regular Visitor

Thanks for your assistance! This is where I am so far and looking to add Running (but Remaining/decreasing) Totals. I looked at the link but cannot relate tbh.  

visual.jpg
aj1973
Community Champion
Community Champion

@elly2212 

Why do you want to create calculated columns? Not good and won't work

Use calculated measures to running total then... Follow thread I sent you 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

aj1973
Community Champion
Community Champion

Hi @elly2212 

check out this

https://community.fabric.microsoft.com/t5/Desktop/Burndown/m-p/1196014

 

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.