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

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

  • IcoLogistica's avatar
    IcoLogistica
    Regular Visitor
    4 years ago

    It WORK!!

    Thanks so much!