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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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

5 REPLIES 5
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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.