Forum Discussion
Power BI Clearing Selection
Hi.
I have decomposition tree which is used to select a location.
That location selection then updates a list of people who live at that location on another tab in my dashboard.
That list of people is shown using a slicer visualisation and in the main works fine.
However, if I make a slicer selection of a person, and then go back and pick another location, that original person from the first location stays selected in my slicer - even though they should not appear in the new people list.
Once I select someone else then they disappear from the list - but how can I stop them from appearing in the first place. I would ideally like my slicer to default select the first item in the list - whatever that is each time
Is this possible?
- Anonymous1 year ago
Im not sure of how you've set your dashboard to filter a slicer in another tab with a decomposition tree in the current tab, but:
You could make the people slicer filter the decomposition tree (by setting the same slicer in the tree tab and sync it), so not to create that logic problem.
Or just transform the Slicer visual to a table or multi row card. This, I believe, would solve the issue; and the visuals can still be used as a slicer, although is less intuitive for users.
2 Replies
- AnonymousNot applicable
Im not sure of how you've set your dashboard to filter a slicer in another tab with a decomposition tree in the current tab, but:
You could make the people slicer filter the decomposition tree (by setting the same slicer in the tree tab and sync it), so not to create that logic problem.
Or just transform the Slicer visual to a table or multi row card. This, I believe, would solve the issue; and the visuals can still be used as a slicer, although is less intuitive for users.- BoRed79New MemberThanks, changing the people selector from a slicer to a table has resolved the issue and I have managed to present the table so it looks a bit like button to click on giving a similar effect - thanks for the quick response.