Forum Discussion
Slicer reflecting table values
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
1 Reply
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
