How to hide future dates in my calendar table

[Asanchez11]

Hi. I am using a calendar tables and i cant hide the futes dates in the slicers and graphs

[v-rzhou-msft · Accepted solution]

Hi @Asanchez11 ,

I suggest you to create a measure to filter your visual.

Filter = IF(MAX('Calendar'[Date])<=TODAY(),1,0)

I can reproduce your issue when my calendar table contains future date.

Add above measure into visual level filter and set it to show items when value = 1.

Result is as below.

Best Regards,
Rico Zhou

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

[lbendlin]

As soon as you add measures based on fact tables these will disappear (unless you have facts in the future)