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...
  • 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(...

     

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

Thanks mickey64 , but I was able to make the correct measure with calculate and filter 🙂

And indeed this way I can have 3 colunm values and 1 line value and the blank is not bothering anymore.

Thanks a lot for putting me in the correct direction! 👍