Chart to display only year to date

[drohm002]

Hello, please see my chart and expression below.  For the 'YTD' line on the graph I dont want it to go down to the x-axis and show all those 0's.  I want the YTD line to just stop at its most current point/most current month, instead of shooting downwards.  How would i get this to work?  Thank you!

=COUNT({<[Exam Status] -= {'X'}, _Scheduled_CurYTDFlag = {'1'}, [WH Exam Type] -={""}, [Scheduled Month Year]-={'$(vCurrentMonth)'}>} DISTINCT [Accession Number])

[Lisa_P · Accepted solution]

Use this expression as the measure:

If(COUNT({<[Exam Status] -= {'X'}, _Scheduled_CurYTDFlag = {'1'}, [WH Exam Type] -={""}, [Scheduled Month Year]-={'$(vCurrentMonth)'}>} DISTINCT [Accession Number]) >0, COUNT({<[Exam Status] -= {'X'}, _Scheduled_CurYTDFlag = {'1'}, [WH Exam Type] -={""}, [Scheduled Month Year]-={'$(vCurrentMonth)'}>} DISTINCT [Accession Number]), null())

[anat]

Try by checking suppress zero values option

[marksouzacosta]

I tried that on my tests, but it did not work as expected for line charts!

[marksouzacosta]

This looks better but does not solve the problem too. It still displays a flat line without any value:

[marksouzacosta]

I think I got it. You have to use @Lisa_P expression but check this property in your chart:

Regards,

Mark Costa

[drohm002]

this worked! thank you Lisa!