Power BI Desktop Grouping function is greyed out an unable to select

[tpk]

I have been trying to group a column using a visual but for some reason am unable to do so.  At first, when multi selecting objects, the group function did not appear as an option.  After I  enabled the visual option for the modern visual header in the Options section, the Group showed up as an option, however, it is greyed out and I am unable to select it.

I am able to create a new group from the Fields pane, however, this takes too long because I have over 1 million rows to select from.

Not sure why I cannot group from visual.  Please help.

[andriychenko]

The feature (grouping/binning) does not work with any live connection to PowerBI/SSAS semantic models and in PowerBI Service - only in thick reports in PowerBI Desktop - so it is pretty much useless for any enterprise reporting. Please cosider upvoting the feature: Microsoft Idea and here: Microsoft Idea

[Telesphoros]

The grouping function selected is for grouping visuals (not grouping of data).

To use the grouping feature on the rick click pop-up windows menu, you must have multiple visuals selected.

If you are referring to groupoing by data, right click a suitable field from the data pane. 

The new group feature will open a new dialog where groupings can be set.

[Logendran_M]

Hi,

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

Let me know if anyone have solution for this

Regards

M Logendran

[tpk]

When I click on the field objects (multi-select or single select), the Group option stays greyed out and is not enabled.  Reading through the link does not discuss this issue.  How do I enable the group option?

[v-janeyg-msft · Accepted solution]

Hi, @tpk 

The group option you see is not for group data. 

It is used for group visual. In this way, the visuals can be dragged together.

Use grouping in Power BI Desktop - Power BI | Microsoft Docs

If you want to group data, choose this:

Or right click on the field name to set:

Use grouping and binning in Power BI Desktop - Power BI | Microsoft Docs

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

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

[amitchandak]

@tpk , Group option will be enabled based on the field you clicked

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