Showing results for 
Search instead for 
Did you mean: 
Advocate II
Advocate II

Matrix functionality question

Good morning,

I would like to check if Is there a possiblity to build complex report using native matrix visual. By complex, I mean combining Columns and Column Total. Please check screenshot below:

-It's a combination of Value by Date - as well as Summarized Measures which I don't want to break-down by day. Rows would be geography. I heard MS was working on +/- functionality of Matrix where you could combine Columns into 1. 

Also, if this not possible, I'd welcome any suggestions! Thank you! 





Resident Rockstar
Resident Rockstar

Hi @wildmight2017,


Yes, the plan for Matrix +/- Collapse/ Expand is started.  You could find this idea in here.


As I know, we could use Drill down in Power BI which is similar with Matrix +/-. 


 drill down.gif


Best Regards,


Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources



We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!


The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors