Filter a slicer by selecting a row in a table (visual)

[aleksvp]

I have a table (visual) with on column, cities. 

I have a slicer with the same column, cities.

When I select a value in the slicer, the table gets filtered. But the other way around (when I select a row in the table) does not work, the slicer does not gets filtered.

Is there a soluction for that?

[YourFriendFred]

Chiming in as well; does anyone know if a workaround is possible as of July, 2024?

I've had a few complaints from my report users about this.

In my scenario, the column has many names so what winds up happening is a user might click a row, scroll away, and then decide to use a slicer to choose a name which winds up with the same issue @YannickM had.

[foodd]

Hello @YourFriendFred , please create a new post with your question rather than replying to another post that has an Accepted Solution.   Please do reference the original post in your new submission.  This will ensure that your question gets seen by more people and answered much faster.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.  Proud to be a Super User!

[YannickM]

Hi, just chiming in, since I run into the same 'issue' (if you can call it that).

I understand that this is by design, but I do think that design is flawed:

If a user selects a value in a table (e.g. city A) and thereafter selects a different value in the slicer (e.g. city B), that results in an impossible filter for most other visuals (city = 'A' AND city = 'B'). A user then first has to undo the select in the table to make the visuals show data again. I find this very un-userfriendly (is that a word?).

As a user I would expect the selections to work together properly, for instance make the selection in the slicer to replace the selection in the table. But I cannot find a way to make this work.

[v-yanjiang-msft · Accepted solution]

Hi @aleksvp ,

It's by design. When we click on charts, the result will not affect to the slicer. We can use slicer to filter table or other slicers, we can also use table to filter table or other charts intead of slicer.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aleksvp]

It is not a relationship problem. I'm using the same column on both. There is only one table in the model (for this example, of course).

[lukiz84]

Set the relationship to "both directions" (bidirectional).