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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
lisampederson
Helper I
Helper I

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

 

POWERBIgraphdata.PNGPowerBIgraph.PNG

1 ACCEPTED SOLUTION
v-chuncz-msft
Community Support
Community Support

@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.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-chuncz-msft
Community Support
Community Support

@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.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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
Helper I
Helper I

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.