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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.