Hiding value for future dates but keeping date on axis

[Anonymous]

Hi All, 

Does anyone know how to hide bars for future dates but keep the actual dates visible on the x-axis? I want my line chart to forecast for the future, but i dont want my bars to be populated for dates > TODAY(). 

i can't seem to get the logic right

PBIX below to show you what it currently looks like. 

Thanks all. 

https://drive.google.com/file/d/1-kUMJJK5lC4Wag8j3jJYcpwJzJzfeR3D/view?usp=sharing 

[amitchandak]

@Anonymous , visual level filter, relative/advance date for last x year years including today. This will not allow future data.

See if this can help

[Anonymous]

Hi Amit, 

The issue is that i still want the x-axis to show future dates as i need the line graph to show forecasting. I just want the bar charts to not populate for future dates as it doesn't make sense since no data should exist for it. 

[amitchandak · Accepted solution]

@Anonymous , In that case control your measure

calculate([measure], filter('Date', 'Date'[Date] <today()))

Hope I it correctly.

[Anonymous]

That worked like a charm. Thanks so much!