Forum Discussion
Filtering out future dates while not suppressing zeros in visual
This issue was resolved by filtering out future dates in the calculated calendar table.
The YYYY-MM is a text column not a date column. So you can not use relative date on it. You would need to add the date column that the YYYY-MM has a relationship to in the filter pane. The reason the YYYY-MM Column is gray out is cause you need to enter a criteria since is a text column.
Hi Bmejia
Thanks for your comment, but I am not using yyyy-mm to filter the visual, and I am trying to filter the visual using "Past date" field which is a calculated column in 445 Calendar table. Despite the selection of "Past date" the filtering is not behaving in the way intended.
This issue was resolved by filtering out future dates in the calculated calendar table.