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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
paulotv
Frequent Visitor

Stacked column charts with two data points

Hi there, I need some help. I am trying to create a stacked column chart that has two related data points on it as below:

 

 

 

Stacked column chart.PNG

I can easily show the by category split by value by gender. But I want to include the data point for the ratio of males to female by category, is there a way to include this? Or is there a better way of displaying this data?

 

Thanks in advance.

 

Paul

 

2 REPLIES 2
v-chuncz-msft
Community Support
Community Support

@paulotv,

 

You may add a measure as shown below.

Measure =
DIVIDE (
    CALCULATE ( SUM ( Table1[value] ), Table1[gender] = "Male" ),
    CALCULATE ( SUM ( Table1[value] ), Table1[gender] = "Female" )
)
Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi there & thanks for your help, I created the measure but when I placed it in the value field of stacked column chart is just divided the gender balance into 50/50, which is wrong.

 

Not sure if the measure itself doesn't do the job or whether its my use of it.  When I use the measur in the chart it displaces the value field I am using there.

 

Can you help?

 

Cheers

Paul

 

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors