Forum Discussion
Table formatting
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?
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.
2 Replies
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.