Slicer won't show all options from Calendar table

[Anonymous]

Hi,

I have a slicer that is supposed to show a date hierarchy for 2022 and 2023. It's connected to a calendar table which does include 2023. Multiple visuals are to be controlled by this slicer and their tables have a relationship to the calendar table as well. 

In the slicer, I only get the option to choose 2022 (and the included months). In other tabs of this dashboard, the slicers work normally and show 2022 and 2023. I have gone over everything and I can't figure out why it won't work on this page. There are no hidden slicers or other filters for dates.

2023 should show up hereConnected to the calendar table

Thanks in advance

[MFelix · Accepted solution]

Hi @Anonymous ,

If the slicer is working properly in other pages this can be related with other filters than not only dates, have you tried clearing all the filters on that specific page and on that visualization and check if any is impacting the date slicer?

[Anonymous]

Hi @MFelix 

you were right. I had filters for dimensions like Brand and others which seem to interfere. I'll have to figure out why and how I can have both the functioning date slicer and additional filters on the pages. 

Can you think of a reason the filters messed with the date slicer?

Thank you!

[MFelix · Accepted solution]

Hi @Anonymous ,

The only reason why a dimension filter would be impacted by other filters is the fact that you have bidirectional filters active in your relationships.

Do you have any bidirectionla relationships active?

[Anonymous]

Hi @MFelix 

I finally had time to check the relationships and there were actually bidirectional ones in there. I changed them and then set up the filters to be page-wide again. Works perfectly. Thanks for helping me with this!

[MFelix · Accepted solution]

Hi @Anonymous ,

If the slicer is working properly in other pages this can be related with other filters than not only dates, have you tried clearing all the filters on that specific page and on that visualization and check if any is impacting the date slicer?