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

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.

Reply
Anonymous
Not applicable

"new" group function is greyed out

as mentioned, please help. 

 

or any other methods can group several countries ?? thank you

12 REPLIES 12
mkiewra
Frequent Visitor

I had the same issue when I tried to group values in the pbix file that was connected to Semantic Model (dataset) published in PBI Service. The solution is to create a group by editing Semantic Model file in PBI desktop. I hope this helps. Best regards Maciej Kiewra (qbico.pl)

Anonymous
Not applicable

Hi,

Is this issue resolved. Right now i'm facing same issue 

Logendran_0-1643784966855.png

Let me know if anyone have solution for this

 

Regards

M Logendran

felixthecatx
Frequent Visitor

I have the same issue.. Power Bi makes the simplest tasks inexplicably complicated. I would encourage everyone on these forums to migrate to Tableau. 

Icey
Community Support
Community Support

Hi @Anonymous ,

 

From the screenshot you provided, I guess that your connection mode is Live Connect.

"Group" will generate a new calculated column in the data table, which cannot be achieved in DQ/LC connection mode.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

savvari
Helper I
Helper I

@Anonymous 

 

Click on the Country column from the Fields pane, you will see New Group as the last option.

Country Group.PNG

 

This opens up the dialog box to group the values.

 

Can you give more information on the column or the data? Are you using the latest version?

 

If this post helps, then please consider Accept it as the solution to help the other members find it more easily.

 

Thanks,

savvari

Anonymous
Not applicable

there is no "new group" from the selection. My version is Sept 2019. 

Picture1.png

Hi @Anonymous 

Please update the version to the lastest one (October 2019 Update (2.74.5619.621))

https://docs.microsoft.com/en-us/power-bi/desktop-latest-update

 

As tested, we can't find "new group" feature in Power BI Service.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thanks so much Maggie, I have downloaded the latest one...but seems no OK

 

Capture.JPGgroup.png

Hi @Anonymous 

When you select from the field, you can see "new group".

Capture12.JPG

 

https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning

https://community.powerbi.com/t5/Desktop/Unable-to-Group-Visual/td-p/646740

 

As tested, when we right click on bar charts, we can group data in this way

Capture13.JPG

But there is no "group data" for items in a table visual.

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Anonymous
Not applicable

sorry still no "new group" from the selection...

I am wondering if I am using the trail version or not...

Hi, I have the same issue having the group function greyed out in the charts and in the field list as well. I have the latest Power BI Desktop (March 2020).

 

Regards,

Janos

I have same issue, not sure if it's because i'm using Publised dataset.... any idea?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.