title: Having trouble building chart from multiple columns in Power BI
body: <p>I would like to create a simple chart from 2 or more columns in Power BI.  </p>
  
  <p>Here's my data, for each column, a 1 marks an occurrence of an event, <em>null</em> means it did not happen.</p>
  
  <p><a href="https://i.stack.imgur.com/cgvjR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cgvjR.png" alt="enter image description here"></a></p>
  
  <p>I would like to turn this data into a very simple bar graph, showing both these fields' numeric totals (i.e. summing all the 1's).  The bars would be shown side by side.  I would like it to look exactly like this, only instead of male/female it would show "alcohol occurrences" and "MDMA" occurrences.</p>
  
  <p><a href="https://i.stack.imgur.com/KeAKO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KeAKO.png" alt="enter image description here"></a></p>
  
  <p>Here's my stacked column chart:</p>
  
  <p><a href="https://i.stack.imgur.com/6UVGx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/6UVGx.png" alt="enter image description here"></a></p>
  
  <p>And when I try and put the column names on the axes so that they can be properly labeled, I get this:</p>
  
  <p><a href="https://i.stack.imgur.com/LYIOZ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LYIOZ.png" alt="enter image description here"></a></p>
  
  <p>I can achieve most of what I want using a clustered bar chart, but the problem there is that it won't let me label the axis with the alcohol / MDMA column names:</p>
  
  <p><a href="https://i.stack.imgur.com/twDOm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/twDOm.png" alt="enter image description here"></a></p>
  
  <p>How can I make a simple, labeled graph, stacking both columns up against each other, showing the numeric sums for each column?  <strong>Again, I want it to look exactly as the male/female example shown above.</strong>  Is this even possible?  Thank you in advance.</p>