In Matrix table filtering data at Qty based on Slicer

[mohitgup20]

Hi ,

I am trying to filter the qty value in the matrix table at each year level, but the slicer is working weirdly.

Currently, I have the below table.

when i try to filter value from the slicer for Qty greater than 50 its removing all the data

The expected output should be that i see value for 2013 and 2014 as its Qty is greater than 50.

Can you please help if I need to create any dax and does the matrix work differently.

@v-cgao-msft @parry2k  @amitchandak @Ritaf1983 @lbendlin @Ahmedx 

[HotChilli]

It's not comparing the same thing.  We know that slicers can't have measures in them but the matrix values will be a measure.

Once you select something in the slicer, have a look at the funnel icon in the matrix and that will tell you what the filter is really doing.