Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
My company has recently adopted Power BI as the progress reporting tool of choice and I'm in process of learning how to use it.
The below screen shot shows a rundown/burndown curve I've developed in Excel. I need to re-create something similar in Power BI. The 'Progress Dashboard' link has a power BI file that I've uploaded the same two spreadsheets required to make the rundown curve as seen in the screenshot.
The common column between the two tables is titled "sub-system".
The "MC Finish Date" table only has two column of importance (Sub-system and MC Finish Date).
The "Checksheets" table also only has two columns of importance (Sub-System and Discipline (Summary)).
I only started reviewing Power BI turorials a few days ago so would appreciate any assistance people can offer.
Thanks in advance.
Solved! Go to Solution.
Thanks for replying Jimmy.
In order for me to make it work in Excel I had to lookup the MC Finish Date for each sub-system from the MC Finish Date table and count how many dates fell in a particular week. Once calculated, I'd tabulate the totals and generate the rundown curve accordingly. The below link shows how I do it in excel:
https://1drv.ms/f/s!Ap_6-ICMV1K6ed9-ueXp0nMNL-0
This is the sequence of activities required to generate in excel:
1. Import MC finish date to checksheet tab (column AN)
2. Count total weekly completed sub-systems (CalcSheet tab - columns K3:EU3)
3. Generate rundown figures for chart (CalcSheet tab - columns K4:EU4)
4. Create chart with above figures (Dashboard tab charts)
Hope this helps shine a bit more light on what I need to develop.
Thanks for replying Jimmy.
In order for me to make it work in Excel I had to lookup the MC Finish Date for each sub-system from the MC Finish Date table and count how many dates fell in a particular week. Once calculated, I'd tabulate the totals and generate the rundown curve accordingly. The below link shows how I do it in excel:
https://1drv.ms/f/s!Ap_6-ICMV1K6ed9-ueXp0nMNL-0
This is the sequence of activities required to generate in excel:
1. Import MC finish date to checksheet tab (column AN)
2. Count total weekly completed sub-systems (CalcSheet tab - columns K3:EU3)
3. Generate rundown figures for chart (CalcSheet tab - columns K4:EU4)
4. Create chart with above figures (Dashboard tab charts)
Hope this helps shine a bit more light on what I need to develop.
Above link now contains solution.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
96 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |