Table formatting

[Anonymous]

Hello,

I'm wanting to create a clustered bar chart showing a comparison of cost/savings for multiple categories. The data come from sharepoint in the following way: 

I am having a problem finding a way to format this to where I am able to put it in a clustered bar. Any help/suggestions? 

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

try to unpivot data https://youtu.be/li0c6R6UpCw?si=8UcW-OG636m7YMqQ

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1.You can select all fields according to the method provided by the super user @Idrissshatila  - Transform – Unpivor Columns..

2.Select [Attribute] – Split Column – Split Column by Delimiter.

3.Result:Using Matrix Visual, place the fields as shown in the picture below, and you can see the grouping comparison

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Idrissshatila · Accepted solution]

Hello @Anonymous ,

try to unpivot data https://youtu.be/li0c6R6UpCw?si=8UcW-OG636m7YMqQ