March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
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]))))
Proud to be a Super User!
Paul on Linkedin.
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]))))
Proud to be a Super User!
Paul on Linkedin.
It WORK!!
Thanks so much!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
85 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
153 | |
97 | |
79 | |
69 |