Forum Discussion
Need help with Line and Stacked Column Chart
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 |
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.
3 Replies
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.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.
oh yes, deneb is a good custom visual solution. Thanks for mentioning it.
