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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

grouping not available when connected to dataset in pbi service

I have a data set created in the Desktop which has been published to the PBI.com service and I have users creating their own reports using this data set. However, it appears that whenever they are using this live connection to the dataset, the Grouping feature is not available. For example, a simple pie chart showing sales by category - if a user selects two or more categories to be grouped, when they right mouse click the Group option does not appear. Is anyone else aware of this and if so is it a bug or is it standard behaviour? Thanks.

Status: New
Comments
v-jiascu-msft
Employee

Hi @jlilleystone,

 

As we all know, there are some limitations in the live mode. The Grouping feature is one of them. We can see from this document, the grouping is the function "New Group". The "New Group" is greyed out in the live connection to Service. I would suggest you vote up an idea here.

grouping_not_available_when_connected_to_dataset_in_pbi_service

 

 

Best Regards,

Dale

jlilleystone
Advocate I

Thanks for the confirmation Dale. Quite a lot of others out there voting for this functionality so have added my name to the list.

 

Regards,

 

John

Anonymous
Not applicable

Hello,

 

Thank you for explaining the situation, I am quite new to PBI. Unfortunately I work with a live dataset and I cannot group any segment. I would like to ask if anyone has managed to create any groups, maybe with a measure? 

Thank you very much!

danieldemasi
Regular Visitor

Its a pain. The only solution is a SWITCH(TRUE() DAX calculated column. It does the same job but its far from ideal.