Relationships when using 2 slicers for multiple tables

[lbudack]

I have the same issue as found under this post: https://community.powerbi.com/t5/Desktop/Using-2-slicers-on-1-report-for-multiple-tables/m-p/60492

However, my data tables have one key difference. The Date table has a 1:1 relationship with the Tables 1-4 (each metric is recorded once per month). When I attempt to change the filter to single direction, I get the error "The filter direction you selected isn't valid for this relationship". 

I feel like this should be a simple fix, but nothing I'm trying is working.

Thanks!

[parry2k]

@lbudack in 1:1 relationship, you cannot change the filter direction to single, it is always both. What actual problam  you are trying to solve?

[lbudack]

I have multiple tables with monthly metrics in them. I have a Date Dimension table, and I have a Category table that are separate from those metric tables. I need to slice by both the date and the categories very much like the example I linked previously, but with only one relationship active between the metrics and the Date Dimension table and one inactive with the Category, it doesn't work. Screenshot of visualization and filters attached. (Date filter works - categories don't)

[v-juanli-msft]

Hi @lbudack

Could you show the relationship view?

Best Regards
Maggie

[lbudack]

Here you go. This is probably hard to read, but each "BSC" table has a 1:1 relationship with the Date_Dim table and an inactive relationship of 1 to many with the Col_Links table. I want to be able to slice by the date as well as the categories in Col_Links. 

(I may end up asking our database admin to move all of this to one table, but I'm not sure how much work is involved to do that. We will be adding more "BSC" tables.)