- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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]))))
Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!
Proud to be a Super User!
Paul on Linkedin.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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]))))
Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!
Proud to be a Super User!
Paul on Linkedin.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

It WORK!!
Thanks so much!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-19-2025 09:00 AM | |||
01-09-2023 11:06 PM | |||
05-18-2025 09:00 AM | |||
05-20-2025 09:13 AM | |||
06-11-2025 12:51 AM |
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |