Forum Discussion

LaraMellor's avatar
LaraMellor
Regular Visitor
3 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    3 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