Progress Curve Visualization with Percent Complete and Forecast Complete

[lisampederson]

Hello,

I'm having difficulties finding a visualization that would work for progress curves.  I keep getting the axis to show something above 1 (or 100%) which I don't understand why that's happening.  See screenshots below.  I'd also like to see a few bars to represent months instead of a sum of all the months in the year.  My data is by month. 

I'd like to just simply show planned % complete, actual % complete, and then forecast % complete if there is no actual.

I also would like to filter the visualization by project.  Each tab in my data is by project and each tab shows the column project and says "project a/b/c".  Will this work?

Any advise would be appreciated!  Thank you.

Lisa

[v-chuncz-msft · Accepted solution]

@lisampederson,

You may first use Append Queries (Table.Combine) in Query Editor or UNION Function (DAX) to combine data, then add a Slicer for project and make use of Drill down in a visualization in Power BI.

[lisampederson]

@v-chuncz-msft

Thanks for the help.  The UNION function was what I was looking for.

The reason my graph wasn't correct was because the axis was "Date Hierarchy" and not "Date."  I didn't know PowerBI made "Date Hierarchy" the default.

[lisampederson]

Link to Data:

https://www.dropbox.com/s/56qlrt5zkwcyt16/SAMPLE%20POWERBI%20Project%20Progress.xlsx?dl=0