Forum Discussion

Asanchez11's avatar
Asanchez11
New Member
2 years ago
Solved

How to hide future dates in my calendar table

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

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

     

     

2 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.