I have created 5 groups of some numbers of a specific column("numbers") in one group "function". I did this with the create groups button of Power BI where i choosed the column "numbers".
GROUP 1: 5000,6000,7000
GROUP 2: 3000,2000,1000
GROUP 4: 9000,9500,10000
GROUP 5: 15000,2300,55000
Then i created a matrix with the groups on the x-axis and the month's on de y-axisis and the values.
Now the matrix gives a total all the groups, but i want to create some sub-totals.
I want to create something like this
SUB-TOTAL OF GROUP 1 and 2
SUB-TOTAL OF GROUP 3, 4 and 5
TOTAL OF GROUP 1,2,3,4 and 5
I hope you guys can help me out.
Go to Solution.
Just add another calculated column and take advantage of drill down.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.