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.