Forum Discussion
Power BI Slicer
Between the two slicers, one is a date slicer and the other is a Brand name slicer applied to the sales table. I would like to apply the date range slicer first. After applying the date range slicer, the Brand name slicer should filter out brands that do not have data on the selected dates, so those brands should not be shown in the slicer.
1 Reply
Anonymous you should create one measure for that :
Brand Slicer =
IF (
Calculate(
COUNT(Brand ID),
TREATAS(VALUES(Date[date]),Brand[Brand Date]))> 0, 1, 0
)
after create this measure put on brand Slicer visual level filter and set Advanced Filtering >> Is 1.
Anonymous I hope this helps you!THANK YOU!!
