Table filter and slicer - how to make table filter change slicer selection

[Anonymous]

Problem:

I have a slicer with user status options, and I have 3 tables showing a user status for different purposes. When I select data from the slicer the tables return only selected data; - GOOD!

Problem: if I select an option in a table - slicer doesn't change (probably it's ok) but then if I use slicer only 1 table updates showing correct selection, all other tables showing nothing

user status selected in the table

then slicer applied and 2 out of 3 tables return nothing

clicking on the value in the table makes other tables to display it too (showing slicer's selection)

Removing slicer selection returns previously applied selection on the table, so I cannot change table selection with the slicer if it was applied via table itself (hope its not confusing  )

All data comes from the same dataset.

IS IT EVEN POSSIBLE?

[v-yuta-msft]

@Anonymous ,

Have made a test but couldn't reproduce your issue. Is enterprise a column name or a value that column? Could you share some sample data and which column are the slicer based on? 

Community Support Team _ Jimmy Tao

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

[Anonymous]

so after the playing around (I am still new!) was noted that slicers on top of the reports are messing with calculations and other filters, such as a row selection in the table. I used DAX for filters to make at least it work with all calculations, however, the issue is still valid:

when I select a row in the table the slicer doesn't reflect that change - i don't know if it should though

slicer and table use the same dataset