Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Stacked column chart

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?

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    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.  

     

     

4 Replies

  • 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's avatar
      Anonymous
      Not applicable

      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's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User

        Hi,

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