Forum Discussion
Connecting lines Stacked Column Chart
- 5 years ago
Zubair_Muhammad not sure if there is something at the market place but you can use a ribbon chart and on the format pane, under the ribbon section, change the transparency to 100% and see if that helps.
- Anonymous5 years ago
Hi Zubair_Muhammad ,
We can use Line and stacked column chart to draw multiple lines to display the value of each column series. We need to create a corresponding number of measures to calculate the value of each series, and put these measures in Line Values.
I created some data:
Here are the steps you can follow:
1. Create measure.
Category-a = CALCULATE(SUM('Table'[amount]),'Table'[group]="A")Category-b = CALCULATE(SUM('Table'[amount]),'Table'[group]="B" || 'Table'[group]="A" )Category-c = CALCULATE(SUM('Table'[amount]),'Table'[group]="B" || 'Table'[group]="A"||'Table'[group]="C" )2. Place [date] on Shared axis, place [group] on Column series, place [amount] on Column values, place [Category-a], [Category-b], [Category-c] on Line values.
3. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Zubair_Muhammad not sure if there is something at the market place but you can use a ribbon chart and on the format pane, under the ribbon section, change the transparency to 100% and see if that helps.