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
Anonymous
Not applicable

Matrix columns are not filtering based on slicer value.

Capture.PNGHi,

I have one dummy date table and i am filtering the report by using that measure in visual level filter (Dos filter is not 0).

Dos filter = SUMX('Tab',IF('Tab'[Lag Aggregate Service Date]>=MIN('Date'[CALENDAR_DATE]) && 'Tab'[Lag Aggregate Service Date]<=MAX('Date'[CALENDAR_DATE]),1,0))
 
This is working is table level. But when same thing i am trying for matrix column it is not working.
I want month of service should get filtered at column level based on STart Date DOS.
3 REPLIES 3
v-juanli-msft
Community Support
Community Support

Hi @Anonymous 

Please try to use the "Dos filter" in the visual level filter of the Matrix visual.

Visual level filter will only apply filter on the specific visual.

Page level filter will apply filter on all visuals on one page.

 

As tested, if two tables have correct relationship, it works for slicer to affect the matrix.

Capture9.JPGCapture7.JPGCapture8.JPG

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Actually in my report i have to show user selected value in date slicer. and i am using dummy date table to filter data from actual table.

Dos filter = SUMX('Tab1',IF('Tab1'[Lag Aggregate Service Date]>=MIN('Date'[CALENDAR_DATE]) && 'Tab1'[Lag Aggregate Service Date]<=MAX('Date'[CALENDAR_DATE]),1,0))
If you see above measure i am using dummy date dimension in slicer and filter actual tab1 table which is in relation with fact tables.
If i directly use tab1 table in slicer then i will get my expected result but i can't show the selected dates at header of report. Because dimension table Tab1 don't have all dates so it will show only min and max values at header level.
Anonymous
Not applicable

Could you explain where you would use a visual level filter on a slicer then? I was trying to limit mine on a date filter and the other visuals don't respond until I physical moved the date range in. If the other visuals won't respond to a slicer/parameter than what's the point.

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.