Forum Discussion
Arranging Data for an Bar Chart
Hi All, I need to arrange the below data so that I get a Bar Chart that has the X-Axis as each 'Task' and then on the Y-Axis a % Completion. If anyone could help I would greatly appreciate i...
Hi Anonymous
In addition to ryan_mayu 's reply, after unpivote the Task columns , you can build a 100% stacked column chart directly.
Add Attribute(Task Name) in X axis, Value(Status) in Legend, and add Value(Status) in Values(use count funtction in this visual)
Result is as below.
You can download the pbix file from this link: Arranging Data for an Bar Chart
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Ryan,
Appreciate your help, however I'd ideally want the X-Axis to have to various tasks. Is this possible?
ryan_mayu
Super User
Super UserAnonymous
you can put values(new name of task after unpivot columns) in the X-ais
updated the attachment as well.