How to create 2 filters

[Bass_Thab]

Hi 

I want to have 2 Slicers between 2 tables. But I can activate only one relation.

Table A has Country and create date

Table B has Country and Create date

Could you please suggest how to use both a Country and Create date in the Slicer?

Bass

[Bass_Thab]

Hi @lukiz84 ,

Do I need to activate the relation too? 

It seems I still can active only one between Date.Create_date --> A.Create_date or Date.Create_date --> B.Create_date

Bass

Bass

[lukiz84]

I don't quite understand... do you want seperate slicers for each table? Or do you want one slicer for Date and one for Country, and this slicer should filter both tables? Could you just post a picture of the relationships in PowerBI?

BR

[Bass_Thab]

Hi @lukiz84 ,

I want one slicer for Date and one for Country, and this slicer should filter both tables.

Thanks,

Bass

[lukiz84]

Ok, then it should work that way...

Maybe you also connected Table A and Table B? Thats not good 😉

[lukiz84]

You need a Country Table and a Date table and connect those to Table A and B.

BR