Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
vamshi_pbims
Microsoft Employee
Microsoft Employee

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.

 

image.png

 

Any help is appreciated.

 

Thanks.

 

CategoryValueTypeState
A10Type 1New
A10Type 1Old
A10Type 1Unknown
A-5Type 2Old
A-5Type 2Old
B15Type 1Unknown
B-10Type 2New
C20Type 1New
C-15Type 2Old
1 ACCEPTED SOLUTION
vamshi_pbims
Microsoft Employee
Microsoft Employee

@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.

View solution in original post

3 REPLIES 3
vamshi_pbims
Microsoft Employee
Microsoft Employee

@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. 

Tutu_in_YYC
Super User
Super User

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_1-1742593220321.png

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors