Forum Discussion
Pivot Chart Novice
Hello, I am struggle and my brain isn't processing what I'm doing wrong. I'm working on making a "dashboard" to visual a series of reports that have been accepted, returned or not received. S...
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 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.