Forum Discussion

BoRed79's avatar
BoRed79
New Member
1 year ago
Solved

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?

  • Anonymous's avatar
    Anonymous
    1 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

  • Anonymous's avatar
    Anonymous
    Not 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.

    • BoRed79's avatar
      BoRed79
      New Member
      Thanks, 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.