Forum Discussion

GrahamR99's avatar
GrahamR99
Resolver I
8 years ago
Solved

Slicer Filter data from 2 different querys

Hello I have a Slicer that filters on Product_Name, I have two maps one for sales and another for stock.   The Slicer is part of the sales data query, and it filters the map for the sales, however...
Need Help
jcarville's avatar
jcarville
Skilled Sharer
8 years ago

You need to join the 2 tables. This could be done by creating a unique list of Product_Names and joining on that.

  • GrahamR99's avatar
    GrahamR99
    Resolver I
    8 years ago

    Hello

    Can you provide the steps required to do so please?

     

    Regards

     

    GrahamR99

    • jcarville's avatar
      jcarville
      Skilled Sharer
      8 years ago

      In Edit Queries, reference the Stock table and remove all columns leaving the Product column. Then remove duplicates from this column and close and apply. In the relationships view the Stock table and sales table should be linked on Product column.