Dimension based Slicer values not filtered based on Fact even with bi-directional relationship

[vickyd]

I have a simple table of transactions with a date field. I've tied the date field to a Calendar table and setup a bi-directional filter.

I thought this would ensure that when I pull a month from the Calendar table, only months that exist in the fact will show up but it isn't. Why?

[Ashish_Mathur]

Hi,

Why do you have a bi-directional filter?  If the relatiosnship is correctly set up, simply drag the months from the Calendar Table to both the slicers and the visual.

[vickyd]

---

@Ashish_Mathur wrote:

Hi,

Why do you have a bi-directional filter?  If the relatiosnship is correctly set up, simply drag the months from the Calendar Table to both the slicers and the visual.

---

I don't think simply month from Calendar table is supposed to give a filtered result since there is nothing filtering that table in a single direction relationship as explained here. 

What I've understood based on this post is that even with a birectional relationship (crossfilter direction = Both) I would need to have some filter on the Fact for it to actually propagate to the Calendar dimension and filter the Calendar dimension. 

E.g. I got the behaviour below only after I added the Payout Value USD is blank as a Report/Page filter. If I don't add the Payout Value USD filter, the Calendar slicer shows all values irrespective of whether relatioship is set with cross filter direction as Single or Both.