Forum Discussion
LaraMellor
3 years agoRegular Visitor
Clustered column chart - gaps in data
Hi there I am hoping someone can help with an issue I have. I have data similar to that shown below. 1 indictaes they attended the course, a zero that they didn't. I want a column chart with th...
- Anonymous3 years ago
Hi LaraMellor ,
Here are the steps you can follow:
1. Power Query -- Select the following four columns -- Unpivot Columns .
Result:
2. Result:
[Attribute] is placed in X-axis
[Value] is placed in Y-axis
Is this way acceptable to you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
DataInsights
3 years agoSuper User
LaraMellor
3 years agoRegular Visitor
I hadn't but I've just tried it and that makes no difference unfortunately.