Alter Data for Pie Chart

[jasonsheeran]

Hello all,

I am pretty new at using Power BI and I am trying to create a Pie Chart visual breaking down Accounts Receivable by its aging buckets. I currently have a query bringing data into Power BI that follows:

I would like the Pie Chart to be a breakdown of Total AR by aging bucket. The legend would be the aging buckets and the values would be how much of the total AR falls into that bucket. How can I transform my current table to fit this? The table also includes other data that is flowing to my other visuals correctly so I do not want to unpivot the table if possible.

Thanks in advance!

[v-yalanwu-msft · Accepted solution]

Hi, @jasonsheeran ;

If you do'n't want to unpivot table ,you could put every column("0-30","31-60"...) in pie chart 's value ,as follows:

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.

[samdthompson]

Hello, easiest fix here would be to unpivot those aging columns in powerquery and create an aging column. You would then use that column as you legend field in the chart.