Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hopefully this makes sense and someone can help me. So I have two tables in my model. The first (called parentDetails) is a list of parents names, their child's name, and what year group that child is in. The second (called surveyResults) are the results from a survey which also contains the parents names, this is how the two tables are linked - in a one to many relationship, the parent can only submit one response to the survey, but they might have multiple children at the school.
My dashboard is very simple so far, I have a table which contains the count of each of the possible options from one of the questions from the survey, and a second table which lists all the year groups from the parentDetails table. When I select one of the responses, the list of year groups changes. When I select one of the year groups to filter the counts of the responses, nothing happens. Why is this? I need to be able to filter the responses to the survey questions based on which year group the parents child is in. but can't figure out what I am doing wrong.
Hi @rflook ,
...I have a table which contains the count of each of the possible options from one of the questions from the survey, ...
How do you calculate this? Please share me your expression.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I tried another route which might give better clarity about the problem. I created a Matrix, and from you can see below, a single value is repeated accross a row. When that option hasnt been selected by a parent for that year group, it correctly is left blank, but what I don't get is the unique values for each cell.
@rflook , how the tables are joined, In a single direction join filter will from 1 to many side.
If there two visual, slicer interaction can be off
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
I figured it out, I just needed to change the 'cross filter direction' option to 'both' in when editing the relationship between the two tables.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |