Forum Discussion
Report Filtering / Aggregation Issue
Hi mmickle23 , hope you are having a great day. You have to work on your model first before anything else. I see many to many relationship between your fact and dim table which is unusual not unless you really understood how it is being used. Otherwise, you can create a dax using userelationship function. DAX Filter - USERELATIONSHIP function
Understanding relationships in Power BI Desktop
Power BI Relationship: Many to Many & Bi-Directional Filtering #Q&A
Data Modeling (Star Schema 🌟) in Power BI – Creating Dimension Tables
If this is one of your first times using powerBI welcome to the community and enjoy the learning.
It appears you are using a Table visualisation to display your data. Table visuals work (essentially) like the Data view for the report creator. It shows the data in a tabulated format and allows you to filter by columns.
For aggregation purposes (grouping data under 1 or more types of filters), you will want to use the Matrix visualisation. This will let you group in rows and columns, and can even have multiple columns that you can drill down into which lets you explore data further.
RE your specific question - Use a Matrix visualisation. Put [fullname] in the rows field, and put [yearid] in the Columns field.
This should group player information by the relevant year.