Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jasonsheeran
New Member

Alter Data for Pie Chart

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:

jasonsheeran_0-1633980143046.png

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!

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1634192107813.png

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.

View solution in original post

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1634192107813.png

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
Memorable Member
Memorable Member

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.

 

 

// if this is a solution please mark as such. Kudos always appreciated.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.