Multiple Bars in a Bar Chart

[djs25uk]

Dear All

Please could you help me? I am trying to create a chart that will show three sets of data, grouped by bands (e.g. £20-15, £15-10, £5-10 etc):

• Count of individual's averaged donations (banded);
• Count of last month's donations (banded);
• Count of this month's donations (banded);

...to look something like this...

I have created the count of individual's averaged donations banded (the black colums) and this works! I am using a calculated column that calculates each person's current average donation and another calculated column that stores which band this is. 

Column that stores the individual's average:

CurrentAverage = ROUND(DIVIDE(SUMX(FILTER(SchemePayment, SchemePayment[SchemePaymentStudentID]=SchemeMember[SchemeMemberStudentID]),[Donations]),RELATED(Student[MonthsInScheme]),0),0)

Column that stores the band for their average:

CurrentAverageBand = CALCULATE(VALUES(Bands[BandDescription]), FILTER(Bands, SchemeMember[CurrentAverage] >= Bands[BandFrom] && SchemeMember[CurrentAverage] <= Bands[bandto]))

I am stuck on trying to add the other two bars to the chart. I have tried lots of different approaches but all attempts so far have produced unexpected results which means I'm clearly doing it wrong. 

Here are my relationships in case they are useful:

The amount of each donation is stored in the SchemePayment table in the column 'Donations' - this isn't the true database column name but has been renamed in Power Bi. 

I would be extremely grateful for any help or advice you may be able to offer. 

Many thanks

Dan

[v-zhenbw-msft]

Hi @djs25uk ,

We have a little confused about your issue.

In your first screenshot, do you want to count how many people donated 20, 15, 10,5? Or do you want to count how many people donated 20-15, 15-10, 10-5?

If you want to show the count of last month and count of this month, the axis should be date, because the axis is 20, 15, 10… cannot determine what month it is.

We know your desire result and your model, but we don’t know what your data, it will become difficult for us to help you solve the problem.

Could you please provide a mockup sample based on fake data or describe the fields of each tables and the relations between tables simply?

Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.