Forum Discussion
Need help on cross filter implementation on multiple Table visuals based on multiple slicers
Hi Team, I have one table called Student table, which is having "studentid","rank", "subject","attendancehours","event name" columns. subject column have data fields "maths","science","overall"...
How you model your data in Power BI will make or break your ability to do this effectively. It sounds like you have lumped all of your data into a single table. What you need to do is create a 2nd table (do this in Power Query) that holds only the Student's details and ID and has 1 record per ID. Make a table relationship between this Student table and your data table.
Now in your table visuals, use the Student table to populate all of the columns (like ID) that are for the student. The remaining columns can come from your data table. You may not even need to write any measures. Now your cross filtering should just work, no complex measures required.