Page dimension and hide header

[Emiliano74]

Hello,

I have 2 problems.

I need to replicate in PowerBI an Excel report.

So, I create a Matrix. In first column there is a Zone and in other columns various measures.

I copied this matrix various times and paste below first one. Each time I change filters in new Visual, but I have a limit in the foot of page. There is a line with dots that is like a limit. I need to go more down. How can I do that? 

Also, when I repeated these Visuals, yes I change filter, but columns are always the same. Is there a way to hide header of columns inside new Visual? I want only first header visible and not others. 

[V-lianl-msft · Accepted solution]

Hi @Emiliano74 ,

you can change the font color and background color the same to hide the header.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Emiliano74 , You can Try Show on row. Add all the measures on same matrix and try show on row = on

and see if that can help