PowerBI Matrix Organizing Columns
Budget: $10 – $30 USD
I'm new to PowerBI, but I'm learning by looking at .PBIX files and trying to see how everything was built, but also watching YT videos. Recently I've been trying to manipulate data so I can have stacked columns that look much like this: Metrics: SPC Quantity > GP > Net Sales Region: YTD CY, YTD PY, YTD VAR%.
Unfortunately, this is where I end up: Metrics: SPC Quantity > GP > Net Sales Region: SPC Quantity > GP > Net Sales. And if I drill down a column I get my desired result, but I can't drill it down on all the Metrics, only one: Drilled Column. It feels almost like I'm missing the most simplest thing that will get my desired result, but I can't figure it out for the life of me.
Unfortunately, this is where I end up: Metrics: SPC Quantity > GP > Net Sales Region: SPC Quantity > GP > Net Sales. And if I drill down a column I get my desired result, but I can't drill it down on all the Metrics, only one: Drilled Column. It feels almost like I'm missing the most simplest thing that will get my desired result, but I can't figure it out for the life of me.