Forum Discussion
Helper Isingle selection in slicer
I have multiple slicers in a report. I want to make "Region" slicer as a single selection, "Name" slicer as a single selection and "Product" slicer as a multple selections. When I select a "ANZ" from the Region slicer and pick a "John" from the "Name" slicer and then choose multiple products in the "Product" slicer. However how I can go back to "Region" slicer to choose a different region (lets say "Southeast Asia" from the Region slicer and pick a different sales name and products for my next search?
Hi,
As I understand, you have multi-table, with the relation between those,
So when you select a(more) value in one slicer, it means you restricted other related table(s).
you select the Name, so you choose the child's one in your model, then if you want to choose another value, you need to clear the slicer, then choose the new search.
it is my opinion, not sure if it is useful
9 Replies
MahyarTFMemorable Member
Hi,
As I understand, you have multi-table, with the relation between those,
So when you select a(more) value in one slicer, it means you restricted other related table(s).
you select the Name, so you choose the child's one in your model, then if you want to choose another value, you need to clear the slicer, then choose the new search.
it is my opinion, not sure if it is useful
Wei2But after I change to single selection, I don't see this icon for me to clear selections.
If I change to multiple selections, I can see clear selections.
So there is no way for me to show all items after I click on one radio button?
- Wei2
Thanks. How come my region doesn't show the icon which can allow me to disable filtering? But I can see other filter having the disable icon?
If region slicer is selected then the icons won't show, but will show on other slicers.
You select the slicer that should not filter other slicers "If I select something on Product slicer I don't want Region slicer to be filtered" so you select Product slicer end disable filtering on region slicer because you dont want product slicer to interact with region slicer.
