Grouping - when new data is added

[jcastr02]

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"

[v-yiruan-msft]

Hi @jcastr02 ，

Could you please provide some sample data? It is better if you can provide your PBIX file.

Best Regards

Rena

[VasTg · Accepted solution]

@jcastr02 

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.

[jcastr02]

This worked! thank you @VasTg 

[amitchandak]

Refer if this can help

https://community.powerbi.com/t5/Desktop/Top-N-and-others-at-the-same-time/td-p/493040