Need help with Line and Stacked Column Chart

[vamshi_pbims]

Hi Team,

Need help with using multiple y-axis measures or columns and a different legend column. PFB sample data.

So I would like to show negative values(Type 2) below the x-axis and positive values(Type 1) above the x-axis for categories, and when i take Category into X-axis and Value into Y-axis by default it is summarizing positive and negative values and giving the result number above the x-axis, and when i place the type column into Legend the result gets correct, but i want to place State column in legend, which is not allowed if i place 2 column or 2 measures into y-axis or if i already placed type column in legend.

and total labels should be shown both for negative side and positive side. 

So basically i want a chart like below but i want my state column to be legend not type column.

Any help is appreciated.

Thanks.

Category	Value	Type	State
A	10	Type 1	New
A	10	Type 1	Old
A	10	Type 1	Unknown
A	-5	Type 2	Old
A	-5	Type 2	Old
B	15	Type 1	Unknown
B	-10	Type 2	New
C	20	Type 1	New
C	-15	Type 2	Old

[vamshi_pbims · Accepted solution]

@Tutu_in_YYC , Thanks for your effort, It doesnt solve my exact purpose. However I could achieve the requirement with Deneb by considering positive and negative values as seperate layers.

Thanks.

[Tutu_in_YYC]

oh yes, deneb is a good custom visual solution. Thanks for mentioning it. 

[Tutu_in_YYC]

Sounds like, you want to positive and negative value to not be summed up, and then should be broken down by State.

This is the closest I could get. Since we can separate the + and - using measures and further breakdown by State.