How to make a merged cell type visual scroll with a long table?

[Anonymous]

I have a table that spans multiple columns, hence have to use scrollbar. However, GATE 2 textbox stays where it is when I am doing this. How would I achieve this?

Is there an easier way to put explanatory visual for three adjacent column headers like this in Excel:

[v-yueyunzh-msft · Accepted solution]

Hi , @Anonymous 

According to your description, you want to create Multi-level tables.

First , in Power BI table visual. It cannot place hierarchical fields. If we want to realize it , we need to use the Matrix visual.

You can refer to this:
(1)This is my test data:

(2)We need to create a custom table as a column header:

(3)Then we can create a measure :

Measure = SWITCH( MAX('Headers'[Sort]),
1, MAX('Table'[For Info]),
2,MAX('Table'[Gate2]),
3,SUM('Table'[Variation]),
4,MAX('Table'[test]))

(4)Then we can put the field we need on the visual and we can get the  hierarchical fields:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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

[amitchandak]

@Anonymous , I doubt you can have that type of display, but for a similar display consider

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
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

Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0