Forum Discussion
Stacked column chart with segment percentage
I'm trying to create a stacked column chart to show a column total at the end, and a value at the base of each column that represents a contributing amount to the total column, presented as a %...as per illustration below.
Dataset looks something like this:
| Dimension | Total Column (Whole Number) | Segment Total (Whole Number) | Segment Total % (Measure: Segment Total / Total Column) |
| Jan | 1000 | 400 | 40% |
| Feb | 2000 | 600 | 30% |
| Mar | 3000 | 500 | 17% |
Any guidance would be much appreciated.
Hi haliddelkic
You cannot put the column [Total Column (Whole Number)] and measure [Segment Total %] in the same stacked column .Maybe you can try another visual , like : Line and stacked column chart .
Put [Total Column (Whole Number)] in Column values , [Segment Total %] in Line values , then turn on Data label in visual format . You can clearly see the value of [Total Column (Whole Number)] and the proportion of [Segment Total %] .
Best Regards
Community Support Team _ Ailsa Tao
2 Replies
- amitchandak
Super User
haliddelkic , what you need to do for that create a stacked line visual with Segment Total %,
with line on Total Column
then you should able to reduce line with to 0 (you might have to enable marker) or same color as background
Hi haliddelkic
You cannot put the column [Total Column (Whole Number)] and measure [Segment Total %] in the same stacked column .Maybe you can try another visual , like : Line and stacked column chart .
Put [Total Column (Whole Number)] in Column values , [Segment Total %] in Line values , then turn on Data label in visual format . You can clearly see the value of [Total Column (Whole Number)] and the proportion of [Segment Total %] .
Best Regards
Community Support Team _ Ailsa Tao
