Forum Discussion
Pivot Chart Novice
zackwilson11 You need to "flatten" (a.k.a. unpivot) the data table first and filter out the unwanted status types. Then create a pivot table on that transformed table. See picture.
I used PowerQuery to create the green table!
File attached.
zackwilson11 You need to "flatten" (a.k.a. unpivot) the data table first and filter out the unwanted status types. Then create a pivot table on that transformed table. See picture.
I used PowerQuery to create the green table!
File attached.
Riny_van_EekelenGreat! One more follow up, my ultimate goal is to use a pie chart for a visual. Is there a way to have to Chart update for all 6 "orgs"? Right now, its not matching the data, or should I just create a new chart?
zackwilson11 Not sure what you mean, but I added a slicer for the Org number, and moved the chart on top of the pivot table. Looked better, I thought.
- Thank you! I'll make that work.
