Forum Discussion
Issue with groups
HI all hope somone can help I have a large dataset and I was trying to create groups for one of the columns. I could create them in the grouping page as lists fne but when I press OK it shows the working on it spinning wheel message and that never clears, not even after hours. Is this an issue with the number of groups I was trying to create or maybe its somethign else? Anyone have any tips on how I could create all the groups I need. Shoudl I make a few at a time then press edit and then add more groups? Any help much appreciated or a workaround also would be excellent.
Hi Ayupchap,
That case, would you please make the sample data more clear and more readable? Would you please show me the sample table as what I have posted above?
If I understand corrently, value like "Grade 6 ELA #1 16 Book 1" is stored in a signle column, right? I think it won't matter. You can split it to multiple columns.
Column2 = LEFT(Table3[Column1],17) Column3 = RIGHT(Table3[Column1],LEN(Table3[Column1])-LEN(Table3[Column2]))
Best regards,
Yuliana Gu
9 Replies
When you say group, are you referring to the "Group By" option in the query editor, or the New Group option when selecting a field?
Also, how large is your dataset?
Hi there
New group option is what I meant, when you right click on a selcted field. The dataset is about 250,000 records pulling from a ODBC linked database table.
I've definitly seen Power BI hang when using the field group option with that many records.
Why not move to a custom column in Query Editor or a calculated column?
