Forum Discussion

paulotv's avatar
paulotv
Frequent Visitor
8 years ago

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:       I can easily show the by category split by value by gender. B...
Need Help
Tips and Tricks
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

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" )
)
paulotv's avatar
paulotv
Frequent Visitor
8 years ago

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