Sharepoint - Visualisation - Grouping

[Anonymous]

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]

Oh I see - sorry  - blast - so there isn't a way to group the sections on one chart, when using the teams set up.  Never mind - thanks so much for your help

[v-janeyg-msft]

@Anonymous 

The second I mentioned is the correct grouping method...You can check the doc first.

Like this:

What are your needs?

[Anonymous]

Hi - So the 2nd Option you originally gave, shows grouping on the same chart - as bellow - however when I go to do this, the Group option is greyed out.

I can't do it on the raw data, as it isn't a true BI data set from scratch, but using the automated visualise option in Sharepoint. 

[v-janeyg-msft]

@Anonymous 

Group should be done in a column in the data.

 'using the automated visualise option in Sharepoint. ' What does it mean?

[Anonymous]

Hi - so when you create a Teams List there is an option to view that list in Sharepoint - when you do - it gives you the following option  

When you select the visuliase the data, it presets you with you a dashboard of charts etc based on the columns of  data in the Teams List /Sharepoint - you can then edit the format of these columns and select different fields to include.

[v-janeyg-msft · Accepted solution]

@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

[Anonymous]

Hi 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?

[v-janeyg-msft]

@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.

[v-janeyg-msft]

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 _ Janey