How to build a filter for a page when you have many tables?

[aline__ester]

Hi guys, I just started my learning in Power BI and I am struggling to deal with many tables at the same time.

I have data from surveys done with students from 9 different classes and with these I need to create a dynamic dashboard where I can filter it according to the class so that all the charts update accordingly.

My data is sensitive because it contains personal information, but I have made a template. I have one table with the general information for each class:

And I have one table per class  arranged this way (in real life there are many other columns): 

Power BI automatically related the tables through the column 'CLASS'. I thought this would be sufficient, but when creating a chart, I was not successful.

Initially I tried to create a chart with data from two classes, but the data clumped together in the chart:

And when I tried to use the filter using the 'CLASS' column from the first table I mentioned, it did not work. When I select class 6, the chart is empty:

Please, how do I proceed from here? (I have seen tutorials for creating page filters but do not know how to apply to my context with many tables). Thank you for you time 😊

[amitchandak]

@aline__ester , If relationship is 1-Many then it is fine.

In Pie visual do not use 2 measures(columns on values) . With legend

use legend or multiple values.

If the join is many to many then consider common tables

https://amitchandak.medium.com/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solutio...