Forum Discussion
Sharepoint - Visualisation - Grouping
I have a Teams List - and I am using the Option to Visualise this List on the Sharepoint back end.
I have many charts and pie charts etc created from the choices made on the lists - howver I want to group some of the columns of data feeding those charts, together to make easier charts - however the grouping option is greyed out -
How can I manage the data so that I can use the option.
Anonymous
I know this function, but it will generate a report directly, not on the desktop. There are more functions that can be operated on the desktop than the service. If you connect the data yourself in the desktop, it can still be used.
Best Regards,
Community Support Team _ Janey
9 Replies
Hi, Anonymous
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
Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ JaneyHi Janey - thanks so much for that clarity - the problem is, when I used the grouping of charts, the 'Group' option is greyed out - and I can't work out why. Doesn't matter what kind of chart I use. Is it because the data is coming via a Teams List to Sharepoint/BI and I am using the Visualise this data option?
Anonymous
Do you understand what I said? The group option you see is not for group data... It will only be useful if you choose more than two visuals.
Anonymous
The second I mentioned is the correct grouping method...You can check the doc first.
Like this:
What are your needs?