Forum Discussion
Creating Groups Hangs
All,
I think I have figured it out. I was adding single data points so that I could use the Other Checkbox option and did not want some data points to be automatically placed in "Other", but I did not want to group with other datapoints. I was also trying to "relabel" some of these data points without changing to backend data, duplicating a column with a different header, etc. After grouped all the items I wanted in Other by my own group name of other, leaving the single items to stay the way they were, it is working without issues.
blindeye and Anonymous, I am note sure if this is why you are also facing this issue, but so far everything is good as long as each group as at least two items.
I have been experiencing this same issue intermittently recently with groups as well on the latest release. I have roughly 600 unique values for one column that I want to group down to about 30 categories. I have roughly 1.3 million rows. Recently, after I try to create groups, the "Working on It" message shows up and nothing progresses even after trying to leave it alone for hours. I end up having to kill Power BI through task manager since the program is still locked and can't create the groups I want. Previously, I was able to create groups on the exact same set. Not sure why sometimes it works and sometimes it seems to just hang. I looked for some limitations on the maximum values of records for groups in the online documentation (https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-grouping-and-binning/), but didn't see any listed.
Also, looks like there is another post that might be related to this- https://community.powerbi.com/t5/Issues/Grouping-stuck-after-changes/idi-p/250097