Forum Discussion

FacuZodi's avatar
FacuZodi
New Member
4 years ago
Solved

Donut Chart with multiple columns as Legends

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

Customertotal banana apple orange date
A15501001/01/22

B

202002/04/22

C

1252503/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!

General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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.

1 Reply

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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.