Forum Discussion

IcoLogistica's avatar
IcoLogistica
Regular Visitor
4 years ago
Solved

Slicer HELP

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

Tips and Tricks
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    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]))))

2 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    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]))))