I have several slicers in use, and each contains large amount of data.
When I choose a filter in one the other slicers adjust, but they still present all the other options "grayed out".
I read a book that explains how to remove all the irrelevant data from the additional slicers (using DAX), so that you won't need to scroll a lot.
Unfortunately, I can't find it
Can somebody share BKM/Exmaple?
When I choose a filter in one the other slicers adjust, but they still present all the other options "grayed out".
I read a book that explains how to remove all the irrelevant data from the additional slicers (using DAX), so that you won't need to scroll a lot.
Unfortunately, I can't find it

Can somebody share BKM/Exmaple?