Chart to display period based on a specific series

[JP_Helsinki]

Hi,

Im trying to figure out how I could limit the displayed period based on a specific series.

1. I have a cumulative series ICM cumulative , that calculates the values from ICM cashflow. When the ICM cashflow does not have any data for the future periods, the cumulative line is drawn horizontally till the dates in my date table run out. 

Question: How could I add a check, that it will only display the value / period until the latest ICM cashflow data / Date and not the "flat line" of the cumulative? 

[v-jayw-msft · Accepted solution]

Hi @JP_Helsinki ,

You could create a measure like

IF(SELECTEDVALUE('axis'[date])>=MIN('period'[date])&&SELECTEDVALUE('axis'[date])<=MAX('period'[date]),1,0)

Add the  measure to visual filter where measure=1 and it will filter out the expected visual.

Best Regards,

Jay

Community Support Team _ Jay Wang

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

[mwegener]

Hi @JP_Helsinki ,

check this out.

https://www.sqlbi.com/articles/hiding-future-dates-for-calculations-in-dax/