Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
jcastr02
Post Prodigy
Post Prodigy

Grouping - 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"

Other.png

1 ACCEPTED SOLUTION
VasTg
Memorable Member
Memorable Member

@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.

Cap11.PNG

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.

Connect on LinkedIn

View solution in original post

4 REPLIES 4
v-yiruan-msft
Community Support
Community Support

Hi @jcastr02

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

 

Best Regards

Rena

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
VasTg
Memorable Member
Memorable Member

@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.

Cap11.PNG

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.

Connect on LinkedIn

This worked! thank you @VasTg 

amitchandak
Super User
Super User

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.