Forum Discussion

rpinxt's avatar
rpinxt
Icon for Solution Sage rankSolution Sage
3 years ago
Solved

Legend problem with line and stacked column chart

Ok this is the situation in a picture: The columns are relates to volumes. And the categories (from the legend) correspond to the volumes.   The line however is based on FTE and the category...
Need Help
  • mickey64's avatar
    mickey64
    3 years ago

    How about use measures?

     

    Affiliate = SUMX(FILTER('Table name','Table name'[category]="Affiliate"),'Table name'[volume])

    Direct =  SUMX(FILTER('Table name','Table name'[category]="Direct"),'Table name'[volume])

    Distributor = SUMX(...

     

mickey64's avatar
mickey64
Icon for Super User rankSuper User
3 years ago

How about use measures?

 

Affiliate = SUMX(FILTER('Table name','Table name'[category]="Affiliate"),'Table name'[volume])

Direct =  SUMX(FILTER('Table name','Table name'[category]="Direct"),'Table name'[volume])

Distributor = SUMX(...

 

  • rpinxt's avatar
    rpinxt
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hmm so you say instead of 1 column Y-axis field, make 3 for the separate legend values?

    Looks like I can only add 1 column y-axis field.

    The line axis could hold more I see but that is of no use.

    • mickey64's avatar
      mickey64
      Icon for Super User rankSuper User
      3 years ago

      I think you can add some measures after you remove 'Category' from 'Column legend'...

      • rpinxt's avatar
        rpinxt
        Icon for Solution Sage rankSolution Sage
        3 years ago

        You are correct.

        Will look into this.

        Somehow my SUMX is not returning data....

         

        Affiliate_units = SUMX(FILTER('AVN Excel Data','AVN Excel Data'[Category]="Affiliate"),[Units])
         
        So maybe if I get this fixed I can solve it like this.