Forum Discussion

MSAYED26's avatar
MSAYED26
Helper II
2 years ago

need help

Hello, I want to the chart continue the line to today , there is no value make it equal zero like chart below 

 

Need Help

5 Replies

  • aduguid's avatar
    aduguid
    Memorable Member
    2 years ago

    Add +0 to the end of your measure.

    Your Measure = SUM('Table'[Value])+0
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi MSAYED26 ,

     

    Thanks for the reply from aduguid , please allow me to provide another insight: 

     

    You can try this.

    Measure = 
IF(SUM('Table'[value]) = BLANK(), 0, SUM('Table'[value]))

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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

    • MSAYED26's avatar
      MSAYED26
      Helper II
      2 years ago

      Thanks for your help ,but i have target line change every qtr not equal zero .

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi MSAYED26 ,

         

        Sorry, I don't quite understand what you are looking for, can you add more description so we can better understand your problem?


        Also, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

         

        Best Regards,

        Clara Gong

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