Forum Discussion
bw70316
7 years agoHelper V
Matrix Total DropDown
I have a matrix that is made up of two categories for the sake of this post. Those two Categories feed into my totals. How do you format data so that I can have a total first row as my drop down in m...
- 7 years ago
Hi bw70316,
If you add both your subcategories in the Rows of the matrix is possible to create a hierarchy that drill down within thew matrix.
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Check the Drill down on row headers part for implementing this.
Regards,
MFelix
MFelix
7 years agoSuper User
Hi bw70316,
If you add both your subcategories in the Rows of the matrix is possible to create a hierarchy that drill down within thew matrix.
https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
Check the Drill down on row headers part for implementing this.
Regards,
MFelix