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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
gftot2
Frequent Visitor

Slicer does not completely filter values in columns from two tables

Hello, In this example, I have two tables where I want to retrieve the column Model and Part Number (they have the same values) and via slicer, look for these references and display both columns.

 

I was able to achieve this by following the solution in this post: https://community.powerbi.com/t5/Desktop/Once-Slicer-for-multiple-columns/m-p/407949

 

The slicer works if I put only those two columns (Part Number and Model), but if I try to add quantities and other values, the slicer does not filter based on search, only put the value searched on top. What I want is to compare quantities and other values from both tables, and that by searching the Model or Number in the slicer, retrieves only the value I want to search.

 

gftot2_0-1642599539832.png

 

 

I believe I read somewhere that it's due to measures, but I'm not totally sure and I hope the community can help me to shed some light here. 

 

Best regards.

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@gftot2 , This is because the measure is only using the filter. and Qty does not.  You need to create a measure for QTY too

 

Ideal is have dimension table joining to the facts

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
gftot2
Frequent Visitor

Hi @amitchandak , thanks for your reply. Sorry, I'm somewhat new to Power Bi, when you say that the ideal thing is to have dimension table, do you mean merging the content of the two tables into one new table?

amitchandak
Super User
Super User

@gftot2 , This is because the measure is only using the filter. and Qty does not.  You need to create a measure for QTY too

 

Ideal is have dimension table joining to the facts

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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