Show only related items in slicer

[PBI_newuser]

Hi,

I have Dimension table that consist of all items.

When I use the field in dimension table, the slicer shows all items in the field.

I would like the slicer only show the related items when certain Fact table is selected.

Dim Table:

Model

A

B

C

D

E

F

Fact Table:

Model	Sales
A	$ 1000
C	$ 120
F	$ 4200

How to show only A,C,F in the "Model" slicer?

[mahoneypat]

You can put a filter on the slicer in the Filters pane with a measure like 

ShowSlicer = IF(NOT(ISBLANK(COUNTROWS(Fact))), 1, 0)

And put that measure on a filter on your slicer visual and "is" 1.

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[Greg_Deckler]

@PBI_newuser - You would need to use a Page level or Report level filter if I understand what you are after. Slicers do not get filtered by other visuals other than other slicers. You *might* be able to use a Complex Selector of some sort. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

[amitchandak · Accepted solution]

@PBI_newuser , Go the visual level filter of slicer and filter sales is not blank or >0

This will work for one slicer too

https://www.youtube.com/watch?v=cyOquvfhzNM