Data model

hello Anonymous 

please check if this what you need.

1. Create relationship of your 'Date' table to 'Table 1' and 'Table 2'.

- 'Date' to 'Table 1' -> Date

- 'Table 1' to 'Table 2' -> Item

2. Plot you Date and Item into slicer visual. While Cost and Revenue in card visual.

Hope this will help you.

Thank you.

Hi Anonymous 

You can connect your Date with both Table1 and Table 2
make sure your relationship from Date  to Table 1 is 1 ->many (Both direction)

and relationship from Date  to Table 2 is 1 ->many (Both direction)


put your slicer on top from Date table filed.

Or you can have bridge table where your unique values of gender/ item will be store . connect your both the tables ( 1&2) with bridge table and your issue will be resolved.

Note: You have to decide the flow of your filter data. It should be from cost table or revenue table. which is the primary or main table. based on that you can take unique value in bridge table and decide the flow like single direction and both direction.
Advice: Never create relationship with many to many direction avoid using that . it creates ambiguity. you can reolved this by using bridge table.

I hope above solution would help you to make your model working.

Thanks yeah i did try that but unfortunately it wont form the relationship between cost and revenue target as it said that the item column in table 1 contains duplicates and that's not allowed for a 1:many or many:1 relationship