stop the measure at the last date in the data model

[gianmarco]

Hi there,

I have the following graph:

Is there a way I can stop the blue line at the last date in the data model? My favourite result would be something like this:

 

Thank you a lot guys

gianmarco

 

[Anonymous · Accepted solution]

Hi @gianmarco ,

Assume you have already get the [last date]

Try creating a measure like:

Measure = IF(selectedvalue(x-axis_date)>[[last date]],blank(),[value])

Best Regards,

Jay