Forum Discussion
Slicer with function ANd
If multi selected in slicker Shop_1 and Shop_2, in table visualisation displayed all products from this shops.
How to display only those products that are available in two stores at the same time? Need method with using slicker.
Hi,
Please find attached the PBI file.
Hope this helps.
6 Replies
Checkout this blogpost for implementing an OR slicer: https://apexinsights.net/blog/or-xor-slicing
Thanks, good article, but it doesn't fit.
I have 1 table and 1 slicer.
Data in my Table:
Products;Shops
Product1;Shop1
Product2;Shop2
Product3;Shop3
Product1;Shop2
If selected Shop1 and Shop2 in slicer, result data in visual table:
Product1;Shop1
Product2;Shop2
Product1;Shop2
But I need to get the result:
Product1;Shop1
Product1;Shop2
Perhaps I missed something? I understand that I have to use dax and use measure to filter the table. Please help me.
Hi,
Please find attached the PBI file.
Hope this helps.
Please help me! I think the solution to the problem should be simple. Once again, the result of the selection on the slicer should be only products that are available simultaneously in all selected stores.
It looks like inner join in sql, but in my case there is only one table.
Ashish_Mathur, this works great, thank you so much! 🙂
You are welcome.
