Forum Discussion

minh23tran's avatar
minh23tran
Helper I
9 years ago

Multiple Bars for clusterd chart

At the moment my data appears as below

Id    Name    Female    Aboriginal    DisbursedAmount

1       John       False      True                      $10000

1       Jack        True       True                      $10000

1       Jill          True        True                      $10000

1       Joan       False       True                      $10000

 

I'm looking to show a graph that shows total disbursed on the y-axis. On the x axis, trying to show count of Female and a Count of aboriginal. I am having a bit of troubles, may I get some assistance. I tried below and it's coming out very strange.

 

 

Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    9 years ago

    Hi minh23tran,

     

    Based on your description that the chart shows total disbursed on Y-axis and ount of Female and a Count of aboriginal on X-axis, the chart output is actually the same as the image you post. 

     

    From the image, I am confused why you add  two values in both axis. Usually, we add category column in X-axis and value column in Y-axis to create a chart.  So, what do you want indeed?  Also, when you used count of Female and count of aboriginal, these two columns are in a same table, so the two count values are always the same.

     

    For more advice, would you please share more detailed information about your expect result?

     

    Thanks,
    Yuliana Gu