Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Matrix columns are not filtering based on slicer value.

Hi,

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.
Need Help
Show and Tell

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    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.

    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.