Donut Chart with multiple columns as Legends

[FacuZodi]

I am struggling to find a way to make a donut chart the way I want it to look.

I have a table like this:

Table1

Customer	total	banana	apple	orange	date
A	15	5	0	10	01/01/22
B	2	0	2	0	02/04/22
C	12	5	2	5	03/11/22

I also made a measure that calculates the average total cost per month, but I don't know if this is how I should build it, or if I should make individual measures for each product's average:

Avg. Monthly Costs = AVERAGEX( VALUES(Table1[date]), [banana cost] + [apple cost] + [orange cost])

I'd like to make a pie/donut chart that shows average monthly costs per product, so it would have "Banana", "Apple" and "Orange" as the legends and the average cost per month as the value.

Any help is appreciated! Thanks!

[v-yalanwu-msft · Accepted solution]

Hi, @FacuZodi ;

We could unpivot columns in power query.

Then create a measure.

averge = CALCULATE(AVERAGE('Table'[Value]),FILTER(ALL('Table'),[fruit]=MAX('Table'[fruit])&&EOMONTH([date],0)=EOMONTH(MAX('Table'[date]),0)))

The final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.