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

 

Need Help
Tips and Tricks

2 Replies

  • 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