Report with 2 headers?

[pedroccamaraDBI]

Hello all

Is it possibel to do a report like this attach?
I have the columns in white but i I need to inform or i need to add those in green to my report. Is this possible? How?
Thanks in advance
Pedro

[v-easonf-msft]

Hi, @pedroccamaraDBI 

Please check if  this pbix file helps.

sample pbix attached

In addition ,you also can refer to these documents.

https://community.powerbi.com/t5/Desktop/adding-second-header-to-table/td-p/735665

https://www.youtube.com/watch?v=0tVPLocU7e0

https://community.powerbi.com/t5/Desktop/Multiple-Header-Column/td-p/595539

https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905

Best Regards,
Community Support Team _ Eason

[amitchandak · Accepted solution]

@pedroccamaraDBI , not out of the box solution. You can manage using these

https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795

[pedroccamaraDBI]

u guys are awesome. Thank you so much!!

[tctrout]

Out of the box, no.

Hackable, yes.

Layer 2 tables ontop of eachother to achieve this.  The top table will be formatted with 3 columns in green, and just simply position it above the table you already have.  

Utilizing layer techniques will provide you many work arounds for desired display.  However, be careful, each visual added onto a page utilizes resources and prolongs the load time of the page.

[collinq]

Hi @pedroccamaraDBI ,

In the Power Query editor you will have to use the pivot/unpivot commands to move the data as you need.  And, you will probably have to use the fill down on the main column that has the pivoted data from the top line of headers. to resolve the nulls.

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!