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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
RobHess05
Helper I
Helper I

Applying separate column filters in a Power BI Matrix

Hello.  I have a matrix that combines data from two datasets.  Each dataset has a date, which I'm using to filter my data.  The problem is that both date filters affect both datasets, which results in incorrect data.  Is it possible to only apply a filter to a specific column?

 

In this example, I'd like the Time Entry Date Entered slicer to filter the Hours columns, and the Service Ticket Date Entered slicer to filter the Tickets columns. 

RobHess05_0-1634842681085.png

 

 

FYI, Service Tickets are a parent record to the child Time Entry records.  I tried changing the cross filter direction to Single, but that broke the matrix.

RobHess05_1-1634842692317.png

 

 

Thank you for reading.

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Filter direction should be single.  Use a different visual or break the matrix visual into two separate ones.

View solution in original post

2 REPLIES 2
RobHess05
Helper I
Helper I

Thank you @lbendlin 

lbendlin
Super User
Super User

Filter direction should be single.  Use a different visual or break the matrix visual into two separate ones.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors