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 s...
Need Help
  • 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.  

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

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
    6 years ago

    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
      Super User
      6 years ago

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