Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |