Slicer HELP

[IcoLogistica]

Hello, I have a slicer for the diferente brands that we sell.  The BRANDS are in the PRODUCT Table.

But in my report I only want that my slicer to show the BRANDS that had sales, sales are in the SALES table.

Can you help me?  Thanks

[PaulDBrown · Accepted solution]

There are options based on the structure of the data. Assuming there is a relationship between the Brand table and the Sales table, you can try the following to use as a filter for the slicer in the filter pane setting the value to greater than or equal to 1:

Filter slicer 1 = COUNTROWS(RELATEDTABLE(Sales Table))

Filter Slicer 2 = COUNTROWS(FILTER(Sales, NOT(ISBLANK([Sum Sales]))))

[IcoLogistica]

It WORK!!

Thanks so much!