Slicer reflecting table values

[DairyG1]

Hi Experts,

Hope you can advise.

I have a table with customer order information that is restricted by a date period.

I want to reflect the customers for that period in a slicer so they are selectable for that period.

In the table there are 15 unique customers for that period, but the slicer shows all customers even though it has the same period restriction.

how can i get the slicer to reflect/align to  the customers listed for that period

thank you for your time

[GilbertQ]

Hi @DairyG1 

What you can do is to use a measure in the slicer such as customer sales > 0, which will allow you to only show the relevant customers.

Here is an example on how to do this: Filter slicers without using bidirectional filters in Power BI - SQLBI