Forum Discussion

asad98's avatar
asad98
Regular Visitor
5 years ago
Solved

slicer filtering based on 2 columns

Hi guys any help will be very appreciated, the case is as follows : - I have 2 tables - Competitor A & Competitor B. Each of them has a column called - "Product Condition" and have a many-to-many re...
  • amitchandak's avatar
    amitchandak
    5 years ago

    asad98 , Create a common dimension product and product conditions or both in one. Join that with both tables and analyze them together

     

    Refer how to create common/bridge table

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
5 years ago

its probably best to create a 3rd table, that has a unique list of the product conditions.   Join both the tables to the product condition table and then you can use the product condition table to slice them.

 

its much easier to help if you can actually show sample data.