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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Regular 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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors