need help

[MSAYED26]

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

[Anonymous]

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]

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

[Anonymous]

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.

[MSAYED26]

Thanks for your time, in count value that cell equal zero and ppm equal zero the target still have value ,so i want the target line continous have value not zero like green line .

	Count	PPM	Target
May-21	2	210	166
Jun-21	1	75	166
Jul-21	2	190	166
Aug-21	6	748	166
Sep-21	0	0	166
Oct-21	3	179	166
Nov-21	1	62	166
Dec-21	3	412	166
Jan-22	0	0	166
Feb-22	0	0	166
Mar-22	0	0	166
Apr-22	0	0	166
May-22	0	0	166
Jun-22	0	0	166
Jul-22	0	0	166
Aug-22	0	0	166
Sep-22	0	0	166
Oct-22	1	40	166

[aduguid]

Add +0 to the end of your measure.

Your Measure = SUM('Table'[Value])+0