Forum Discussion
Using a slicer to filter 3 different databases
Hello folks,
Im working on 3 separate databases (sales for 2021, 2020, 2019) which they resemble the operating years of x department. Im trying to use a graphic to show some features of these items sold (in this case would be size) and I would like to use a single graphic to show this. Is this possible?
Thanks again,
1 Reply
Shackwell
It depends. The first suggestion would be to append the three tables using power query then you can slice by year.
If you want to keep them splitted for some reason, and you are for example slicing by product then you need to have a product dimention table that contains a unique list of all products. Can be easily created using power (preffered) if not possiblr then it can be created using simple DAX code. Would you please provide more details in order to assisst you further. Thank you.
