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 my matrix? Basically, I want the viz to open with just the Total rows and the Services/Social Services inside of it. Not Pictured is what I am going for. The following Pictures would serve as dropdown click 1 and dropdown clikc 2
IMAGE 1 : SHOULD BE A PIC OF JUST THE BUDGET TOTAL ROW
Image 2: One Drop Down Click
Image 3: Two Dropdowns
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
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
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
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
FabCon &SQLCon Highlights
Experience the highlights from FabCon & SQLCon, available live and on-demand starting April 14th.
