Stacked column chart with segment percentage

[haliddelkic]

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. 

[Anonymous · Accepted solution]

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

[amitchandak]

@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