Forum Discussion
Solution SageLegend 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 field for those lines is empty (blank).
Therefore in the legend (Blank) is showing, but we want this gone.
However when we in the filter pane switch off (Blank) also the line will dissapear!
This because for all the line FTE values the category is blank, so excluding this also excludes the values for the line...
Is there a descent way to fix this??
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(...
6 Replies
- mickey64
Super User
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(...
rpinxtHmm 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
I think you can add some measures after you remove 'Category' from 'Column legend'...