Stacked column chart

[Anonymous]

Hello  -   I have two measures in the value area.    Nothing in the Legend.  

I can't seem to be able to put anything in the Legend area.    When I put both measures in the value area, only one shows up.  

What am I missing?

[Ashish_Mathur]

Hi,

In the legend you cannot drag measures.  You can only drag columns from your table there.  Try to plot the green measure on the secondary Y axis.

[Anonymous]

Hello @Ashish_Mathur     This needs to be a stacked chart  (not a combo chart).   

Yes, I do need a column in the legend area.   But for some reason I am not able to drag any column to that area.   

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.  Let me know the exact chart that you would like to create.

[Anonymous · Accepted solution]

@Ashish_Mathur   Thanks Ashish.    Was solved simply enough.    First, after searching the issue I found that you cannot have two values in the values area, if you also have something in the Legend area.    

Then I realized I could just create the two distinct count measures I needed, and put them in the values area, with no legend, and it got me what I wanted.