Group several columns

[Anonymous]

Hello everyone,

I have a question: do you know how to group several rows of a table together? Here is my table:

It turns out that the databases have been a little mismanaged and it's not very clear so all the CSRs should be grouped together to make it easier to read.

To be more precise, I would like "CSR Energy Mutation", "CSR Special Conformity", "CSR Special Wasabel", "CSR Special Esabel" and "CSR Special Water Resource management" to be grouped together under the name "CSR".

Thank you for your help, 

Emilie ❤️

[jcalheir]

Hi

If you want to preserve your data and dont user powerquery you can create list groups and group all the values so that you can use them in visuals.

Check this video on minute 2.18 in order to understand the feature

https://youtu.be/D1LO8syugMA?t=138

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

[Newbie22 · Accepted solution]

You can customize group name in Query Editor/Power Query.

Try conditional column. All that begins with "CSR" put it under CSR. Then drag the new group to your visual.

[Anonymous]

Yes thanks for taking time to respond to me, it worked ! 

[lukiz84]

Hi,

the easiest way is to change it via PowerQuery in the Import Step.

You can just replace all values that contain *CSR* with CSR.

Please see:

https://support.microsoft.com/en-us/office/replace-values-power-query-28256517-f1e9-4dc3-832f-45786e...