Forum Discussion
german_f2016
Nov 19, 2023Copper Contributor
Nested Slicers loose the ability to reflect sub-group selection
When working properly
and when not working properly:
I had my pivot table converted to formulas using the OLAP tools and now the slicers seem to work, but don't communicate between them (when the pivot table was present, the slicers showed the correspondent parent/child items in the other slicer). Is there a way to fix this? please advise.
Thank you,
Jan, having the pivot table back in a single cell connected to the slicers did the trick! The visual aid is working now.
Regards,
- JKPieterseSilver ContributorWell, I assume the slicers no longer affect the values calculated by the formulas. Do they?
- german_f2016Copper Contributor
Hi Jan,
Actually, they work fine. The problem is that the two slicers do not give a visual clue of what is being selected in the other slicer. Before the conversion to formulas, when you selected one element in the right-side slicer, the left-side slicer dimmed out the boxes not related to the selection.
- JKPieterseSilver ContributorPerhaps you could add the pivot table back again, but with only a total row (so just a sum field and no row or column or page filters). Tie that toe the slicer and it should work again?