On the dashboard I want to have two identical tables that will be filtered with one slicer ('Skill' column used) with several options to choose from. Table 1 should have an additional filter 'Priority = 3', Table 2 should filter 'Priority = 2'.
What I want to achieve:
(1) when the slicer doesn't have any options selected, both tables should be empty; (2) possibility to choose several skills in the slicer;
(3) when I choose one skill in the slicer, the tables should show all rows from the dataset for positions with this skill and, depending on the table - with a priority of 3 or 2; (4) when adding each subsequent skill in the slicer, the table should show records only for those positions that have only the selected skills and, depending on the table, priority 3 or 2.
I would be very grateful if someone could help me with this. If it is not clear, please ask additional questions, I will try to explain.
I know that in case of priority I can apply a filter for a specific visual and I did that. I would like the lack of a selected option in the slicer to show only the table headers. Currently, the table shows all rows for the condition 'Priority = 3'.
The second issue is to change the slicer logic from OR to AND. I probably did not explain my problem well enough. After selecting one skill from the slicer (Skill 1), the table should show all the rows that contain that skill (see below).
The problem I struggle with is choosing more than one skill in the slicer. After selecting two (Skill 1 and Skill 2), the table shows these rows:
but I wish it would show these:
Because only 'Position 3' has both of these skills with priority 3. I would like to achieve the same effect by selecting 3 skills and more at the same time. Is it somehow possible?