Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Shackwell
Helper III
Helper III

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 1
tamerj1
Super User
Super User

@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.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.