Forum Discussion
Helper VDimension based Slicer values not filtered based on Fact even with bi-directional relationship
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?
2 Replies
- Ashish_Mathur
Super User
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.
