Forum Discussion
Dynamic Slicer using parameter
Can you provide some sample data and expected results? It will be really helpfull what do you want to achive. 🙂
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
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. 😄