Forum Discussion
Post ProdigyGrouping - when new data is added
Is there a feature where grouping works whenever new data it buckets it into an "Other" category? Example - I have a question on a survey where team members are asked where they find help when needed. The survey gives them options for a) Internal online resource 2) Peer 3)Supervisor and they have a free text response area. I grouped the remaining responses into "Other", but when new data is added, I find myself having to manually group. Is there a rule that can be written that if it's not one of the first three responses, then bucket to "other"? I have a tool tip to show the drill down "other"
It does..
You could create a test by going to Enter Data and key in values A,B,C and create a group for A->A Group; B->B Group and check the Include other Check box.
Now go to edit queries and add few more rows. Those rows will appear in Other group. You could verify it in Reports page as well.
If this helps, mark it as a solution
Kudos are nice too.
4 Replies
- VasTg
Memorable Member
It does..
You could create a test by going to Enter Data and key in values A,B,C and create a group for A->A Group; B->B Group and check the Include other Check box.
Now go to edit queries and add few more rows. Those rows will appear in Other group. You could verify it in Reports page as well.
If this helps, mark it as a solution
Kudos are nice too.
- amitchandak
Super User
Refer if this can help
https://community.powerbi.com/t5/Desktop/Top-N-and-others-at-the-same-time/td-p/493040
Hi jcastr02 ，
Could you please provide some sample data? It is better if you can provide your PBIX file.
Best Regards
Rena
