Dynamic Slicer using parameter

[Sudharsanan]

Hi friends,

I have a scenerio where 2 tables are not connected for some reason, but i want to create a slicer where the 2 table should interact only with slicer and not with the data. it is possible?

Thanks in advance

[Sudharsanan]

@bolfri yes i understand that, here the case is, all the emp supports all the team, so based on the task they do the team is shown. for example, you may support me in some task, so when i select my team you should be comming under the list whereas you belong to different team.

[bolfri]

Can you provide some sample rows eg for 2 teams and few employees and show the expected results? You can use name like John Smith, Joe Doe etc It doesn't metter. 😉 It will be easier to understand and provide a solution.

[bolfri]

Can you provide some sample data and expected results? It will be really helpfull what do you want to achive. 🙂

[Sudharsanan]

Thank you @bolfri  for the quick response.

for example i have a table called "Team" and another table called "Emp name", here the emp name may work in different team, so i have already created a measure for that. but now i am facing an issue like if i select the a particular team in the slicer, the Emp name slicer is not filtering the names for the selected team, instead i am getting all the names, so trying to find a solution.

hope i have made it clear for better understanding

[bolfri]

Why don't you create table(s) with relationship to cover that issue?

Table 1) dim_team collects information about team_id, team_name, team_leader, team_description etc.

Table 2) dim_emp collects information about emp_id, emp_name, emp_surname, emp_salary etc.

Table 3) fact_teams holds an information about which emp is in which team, emp can be in different teams

Then you are using relationship table 1 to table 3 and table 2 to table 3 to cover all the cases that you are facing 🙂 Power BI will do the rest for you. 😄