Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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"
Solved! Go to Solution.
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.
Hi @jcastr02 ,
Could you please provide some sample data? It is better if you can provide your PBIX file.
Best Regards
Rena
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.
Refer if this can help
https://community.powerbi.com/t5/Desktop/Top-N-and-others-at-the-same-time/td-p/493040