Stop accumulative line

[Anonymous]

Hi All,

I need your help.

I have graph showing accumulative lines of forecast, actual etc.

i used this qury to make lines in graph.

CSU SP_Contractual =

CALCULATE(

    COUNTA('Data - CSU SP PO'[CONTRACTUAL_DELIVERY_DATE]), USERELATIONSHIP('Data - CSU SP PO'[CONTRACTUAL_DELIVERY_DATE],'calendar'[Date]),

    FILTER(

        ALLSELECTED('Calendar'[Date]),

        ISONORAFTER('Calendar'[Date], MAX('calendar'[Date]),desc)))

and the graph look like below

 as you can see the lines doesn't stop even though they have same value.

what i want to show is lines till they have value..

i don't know what relationship they have so lines goes forever...

any ideas?

regards,

CL

[amitchandak]

@Anonymous , try like

You try using the date from table in max

CSU SP_Contractual =
CALCULATE(
COUNTA('Data - CSU SP PO'[CONTRACTUAL_DELIVERY_DATE]), USERELATIONSHIP('Data - CSU SP PO'[CONTRACTUAL_DELIVERY_DATE],'calendar'[Date]),
FILTER(
ALLSELECTED('Calendar'[Date]),
'Calendar'[Date]<= MAX('Data - CSU SP PO'[CONTRACTUAL_DELIVERY_DATE])))

Can you share sample data and sample output in table format?

[Anonymous]

hi @amitchandak  

i tried the formular and the graph doesn't look right..

[v-kelly-msft]

Hi  @Anonymous ,

Can you pls upload your .pbix file to onedrive business and share the link with us?

Remember to remove the confidential information.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!