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 August 31st. Request your voucher.

Reply
citr10
New Member

Filtering

Hello. I need help about using two date slicers in one table. I have 2 table. First table include date, product, quantity. Second table include date and id. So I want to show all product and their relevant sum of quantities on matrix table with 2 date selection. But problem is that when I select first date and then second date, it's only shows products selected at first date. I'll appreciate your help. P.S. Screenshots atached.

 

84703118-7fe4-4dd1-b5e1-92876ad63e03.png

ss2.pngss3.pngss5.png

fc208485-96aa-4665-bfd0-226416949b0c.png

4 REPLIES 4
ray_codex
Resolver II
Resolver II

Maybe a open door, but why are you trying to do this and not using one date table with one date slicer?

Dangar332
Super User
Super User

HI, @citr10 

use edit interaction  feature refer HERE 

use edit interaction bw your both slicer so not interact with each other

 

I already did it. I think problem is in measures.  

hi, @citr10 
try to remove ALL() function from both measure

use only sum(product[quantity])

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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