cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

group headers in matrix

Hi,

 

I am trying to create a fairly complex sales report using a matrix. I want to show monthly sales for each item across multiple years, plus some additional information (e.g. current quanity on hand). 

 

My power BI matrix currently has 2 row variables (item and year), one for columns (month) and one for values (sales):Screen Shot 2017-06-21 at 2.33.26 PM.png

I am looking for a way to create a group header that would print once per item and show some additional information (e.g. price of the item). Below is an example of what I want to create, with a red box added to the group header to obscure some item details for anonymity of our client. 

Screen Shot 2017-06-21 at 2.35.19 PM.png

Is this possible in power BI?  I am a neophyte so apologies in advance if this is a naive question.

 

Thank you,

Thomas

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: group headers in matrix

Hi @tomHarrison,

 

As far as I know, there is no such group headers option in Matrix visual in Power BI currently. You can submit your requirement on Power BI Ideas to improve Power BI on this feature. Here is a similar idea for your reference. Smiley Happy

 

Regards

View solution in original post

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: group headers in matrix

Hi @tomHarrison,

 

As far as I know, there is no such group headers option in Matrix visual in Power BI currently. You can submit your requirement on Power BI Ideas to improve Power BI on this feature. Here is a similar idea for your reference. Smiley Happy

 

Regards

View solution in original post

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors