Multiple Bars for clusterd chart

[minh23tran]

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.

[v-yulgu-msft]

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