Forum Discussion
Subtotal Percentage on Row matrix
Hi guys
I am trying to create a matrix on power bi, and it should appear like this. How do i create a High Mix, Mid Mix, Low Mix on power bi?
On the rows, I have store names, and on columns I have Product names by Quarter and Year to date.
The % should be by product for each store, and by the high, mid, low.
Appreciate any help on this.
1 Reply
Here's a solution but it will be a lot of work.
You can consider Calculation Groups. You can also consider talking your business users down to simplifying the requirement.
Worst case, tell them to stick with Excel for this one.
