Calculating Cumulative Progress of a project

[ParsaOmidvar]

Data is about planned progress percent of multiple projects in multiple phases.
so there is projectid, planid, palnned percent, phase id, yearmonthid
what i want is to show the line for different plans, have slicer for each phase and show the actual progress (which is in another table)
i have written a dax measure which when you use it with legend for multiple plans and slicer for different phases returns multiple lines and correct values.
now i want to add Actual measure to visual but i cant, cause i am using a legend, how can i work around that?

[Anonymous]

Hi Kedar_Pande, thanks for the quick reply, I'll add more.

Hi @ParsaOmidvar ,

Regarding your question, could you provide some simple data and show the expected results as a picture?

If you are unsure how to upload data please refer to

How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Best Regards,
Wenbin Zhou

[ParsaOmidvar]

I have a table like below
cause it's SCD we have surogate keys and when a plan id changes it shows. i want to have cumulative progress of each plan and phase, i've written the measure but i have to use a line chart legend to differ the plans and use a slicer to filter base on phase, i am trying to find a way not use the legend or find a line and bar chart with legend option for line

Projectid	SurogateKey	Phaseid	YearMonthid	PlanId	ProgressPCT

[Kedar_Pande]

@ParsaOmidvar 

Consider creating a single combined measure that dynamically switches between planned and actual values based on a new column that defines categories.

Combined Progress =
SWITCH(
TRUE(),
SELECTEDVALUE('Project'[Category]) = "Actual", [Actual Progress Measure],
[Planned Progress Measure]
)

Add the Category column to the Legend field of the chart.
Use the Combined Progress measure for the Y-axis.

💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[ParsaOmidvar]

Thank You Kedar, but I want them in a single visual without differing them with legend
I wrote a Calculated Table and labeled actual and planned data, but now I have to use a barchart and line chart to show the progress monthly too, so the problem is how to have a measure that automatically detect any replanning and show them but not using legend
although if there's a modified Line and bar chart with option to give line a legend that'll do