Forum Discussion
GrahamR99
8 years agoResolver I
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...
- 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.
GrahamR99
8 years agoResolver I
Hello
Can you provide the steps required to do so please?
Regards
GrahamR99
jcarville
8 years agoSkilled Sharer
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.