Filter showing all values

[srlabhe123]

Hi Team,

Please find snapshot from data model below.I am trying putting filter on Material Type circled it shows all vallues form table.

But when I put the same column in report in combination with some columns of Prewave SKU Summary it just shows data for 2 material types.

How would I make sure my Slicer on material type should also shows only those 2 Material Types from data andnot anything else.For ex Mateial Type from SKU and Profi Center has types as ABC,PQR,XYZ,LMN,EFG but when added to report in combination with some dimenssion of Prewave SKU Summary it jus shows ABC,XYZ.

My slicer on Material Type still shows all 5 material types rather I wana slicer to show only 2 from data.

Please note this is directquery report.

[Greg_Deckler]

Add a Page Level Filter for Material_Type and then use Basic Filtering to select only those two values?

[srlabhe123]

Thats not want.... page level filter will always restrict what I have selected. But I want slicer to show only those values which are in data.So today it may have 2 values tomorrow may be different set of values.