Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Stop accumulative line

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

Need Help
Show and Tell

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      hi amitchandak  

       

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

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        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!