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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
ashmitp869
Responsive Resident
Responsive Resident

Matrix visual didn't filter - when Leave Codes selected. Guidance required

Hi All,

 

I have a sample pbi file. The Data model looks like this.

https://github.com/suvechha/samplepbi/blob/main/sample.pbix

 

ashmitp869_0-1724735991164.png

 

I need to filter with Leave Codes. But my Matrix visual is not working with Leave Codes selection.

Please guide me, what I am doing wrong. 

 

ashmitp869_1-1724736095248.png

The Filter is working with raw data.

But my matrix didn't filter.

 

ashmitp869_2-1724736142444.png

 

1 ACCEPTED SOLUTION
sunilprajapati
Regular Visitor

Between Leave to Date table change Cross-filters Direction from "Single" to "Both"

sunilprajapati_0-1724738516839.pngsunilprajapati_1-1724738534132.png

 

View solution in original post

1 REPLY 1
sunilprajapati
Regular Visitor

Between Leave to Date table change Cross-filters Direction from "Single" to "Both"

sunilprajapati_0-1724738516839.pngsunilprajapati_1-1724738534132.png

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.