Forum Discussion

yazenbarakat123's avatar
yazenbarakat123
Helper I
3 years ago

Stop Plotting Line on Chart when Activity is completed

Hello I am trying to have my line chart stop plotting when an activity is marked as completed Bellow is a sample Data set of a Milestone Schedule Report I am working on,   I am using the custom M...
Need Help
Kishore_KVN's avatar
Kishore_KVN
Solution Sage
3 years ago

Hello yazenbarakat123 ,

I am not sure with the approach you made for the line visual. But you can try below measure by tweeking it as per your data design.

Measure = IF
            (
                CALCULATE(MAX(Data[Activity Status]),ALLEXCEPT(Data,Data[Miestone Description]))>0,
                CALCULATE(COUNT(Data[Reporting Date]),FILTER(All(Data),Data[Activity Status]=1 && Data[Reporting Date]<=MAX(Data[Reporting Date]))),
                CALCULATE(COUNT(Data[Reporting Date]))
            )

 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

yazenbarakat123's avatar
yazenbarakat123
Helper I
3 years ago


I am running into this Error when trying to replicate your measure