Forum Discussion
Grouping with values in multiple groups (for filtering)
Hi everyone,
I'm stuggeling with the following task:
I've a dataset with players and theirs stats. And I want to create some grouping where I can filter to only the stats that are recuired for the selected group. But the issue is.... one stat could be required in multipe grouping. So for example stat1 is necesarry for group 1, 2 and 4 and stat2 is necesaryy for group 2, 3 and 4 and so on.
How can I set this op in power BI?
4 Replies
Hi， Anonymous ；
Can you give an example of a screenshot to illustrate it? And what you want to output so that you can understand your logic?
The most important parts are:
1. Sample data
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thanks for your reactie Yalan.
This is a sample what I'm trying to accomplish:
Shooting Passing Crossing Tackling MArking Running Heading Attacking Midfielder V V Central Defenders V V V V Defence Midfielder V V Full Back V V V V V Goalkeepers V V V Strikers V V V Wingers V V V V So that when I filter on 'Central defenders' that I only see the values of Passing, Tackling, Marking and heading. And when I filter on 'Full Back' I see the values of Passing, Crossing, Tackling, Marking and Running.
This means that, for example, Tackling belongs to group 'Central Defenders', 'Defence midfielder', 'Full Back and 'Goalkeepers'. I know how to set this up when each category belongs to one group but how to set this up when a category belongs to multiple groups.
Hi, Anonymous ;
So what do you want the output to be? I'm sorry I understand your form a little bit, but I still don't know what you want to do.
The plan is to create a radar chart that will only show the categories belongs to the group that is selected. So if the group 'Central Defenders' is selected only the numbers of passing, tackling, marking and heading will be showed in the radar chart. But when the group 'Strikers' is selected only the numbers of shooting, running and heading will be showed in the radar chart, the others will not be showed.
My dataset contains 50+ stats so I can't show them all in one chart. So is it possible to create a filter option that will only show the relevent stats of the player according to the selected group? knowing the one stat could be applicable for more than one group items?
