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
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.
Solved! Go to 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.
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
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.
Hi,
Is this issue resolved. Right now i'm facing same issue
Let me know if anyone have solution for this
Regards
M Logendran
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:
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.
@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
User | Count |
---|---|
123 | |
96 | |
89 | |
73 | |
63 |
User | Count |
---|---|
138 | |
115 | |
111 | |
98 | |
95 |