Forum Discussion

Bass_Thab's avatar
Bass_Thab
New Member
3 years ago

How to create 2 filters

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

 

Need Help

5 Replies

  • lukiz84's avatar
    lukiz84
    Memorable Member
    3 years ago

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

     

    BR

  • Bass_Thab's avatar
    Bass_Thab
    New Member
    3 years ago

    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's avatar
      lukiz84
      Memorable Member
      3 years ago

      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's avatar
        Bass_Thab
        New Member
        3 years ago

        Hi lukiz84 ,

         

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

         

        Thanks,

        Bass