How to merge column header cells (like table colspan) in Power BI?

[Allen1314]

Hi, is it possible to show a table (maybe use "Matrix") like the following picture in Power BI? And how?

[jaipal]

@Allen1314 it's obvious, if you have more fields in row level, you need to move the scroll bar to move lef and right to see the values. You have too much space between Custome, Date, Type and Method columns. To reduce the space, adjust the columns lenght and remove + , - icons. That will save a bit of space. 

[Allen1314]

@jaipal 

my real case as follows, there have so many fields to be Rows, and it won't scroll left when scrolling, only the fields as columns (Qty/ Unit Cost/ Amount) can scroll left now
What I want is All fields scroll left togethor (even the fields selected as the Rows)

[jaipal]

@Allen1314 got you, in Matrix, the rows are constant. There is no feature you can move Rows. 

In this case you can download and use custom Matrix tables from more visuals.

[Anonymous · Accepted solution]

Hi @jaipal ,

Based on my research and testing, currently the matrix does not support horizontal scrolling of the Rows fields.... Please review the workaround in the following thread, hope it can help you.

Matrix not allowing horizontal scroll in Power BI Desktop or Online (IE11, Chrome, etc.)

Hey - when you have enough row groups in a matrix so that they don't all fit in the viewport, the scroll bars are disabled. This is because scrolling normally only affects the values area of the matrix. If you've got lots of text data, try using a table instead? Hope that helps Will

---

This is not a perfect solution but a good work around 

You can increase the size of the sheet to include all the table . 

Bellow link explain how to do it 

https://community.powerbi.com/t5/Desktop/Create-Reports-with-Vertical-Horizontal-scroll-bar-on-pages...

In addition, you can raise a new idea and add your comments there to make this feature coming soon. Or the following one is one similar idea shared on Power BI Ideas, you can vote it up and add your comments there to improve Power BI on this feature.

Allow Matrix table to scroll horizontally for large number of rows

Best Regards

[jaipal]

@Allen1314  yes it is possible with Matrix table. Drop Customer, Date, Tyoe and Method in Rows level.

Put remaining Columns in the column level. Trun Drill on in column level, click last button.

You need to put Measurs on Values field.

Let me know if you still struck.

[Allen1314]

@jaipal thank you for your help, it works for me, but there have one more issue, the field selected as rows can't scroll left when there have too many fields exists, so if I have more fields needs to be selected as rows, it maybe occupy the whole width of the screen, then others values can't see any more, do you have any idea?