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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
tpk
New Member

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

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.

tpk_0-1606799408551.png

 

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.

 

1 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:

vjaneygmsft_0-1643947749806.png

 

Or right click on the field name to set:

vjaneygmsft_1-1643947749909.png

 

 

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.

View solution in original post

6 REPLIES 6
andriychenko
Frequent Visitor

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
New Member

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. 

 

Telesphoros_0-1711722101698.png

 

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

 

Logendran_M
New Member

Hi,

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

Logendran_M_0-1643785492386.png

 

Let me know if anyone have solution for this

 

Regards

M Logendran

tpk
New Member

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?

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:

vjaneygmsft_0-1643947749806.png

 

Or right click on the field name to set:

vjaneygmsft_1-1643947749909.png

 

 

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
Super User
Super User

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
October NL Carousel

Fabric Community Update - October 2024

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