Forum Discussion
jasonsheeran
4 years agoNew 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...
- 4 years ago
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
Memorable Member
4 years agoHello, 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.