Forum Discussion
Progress Curve Visualization with Percent Complete and Forecast Complete
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
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.
3 Replies
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.
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.
