Table visual - split into to or more visuals?

[tmul]

Hi, 

I have the following problem. I am supposed to make a one pager with some information from several tables. 

I can display all the information in one table visual without any problem but then people need to scroll and do not have all the information available. 

I was wondering if there exists something like a table grid for Power BI which would be able to split one table into two or more to see more data in one view. 

Example: I would like to split this table in a visual! (not in PowerQuery)

Key	Name	Year
1	A	2000
2	B	2002
3	C	2000
4	D	2003
5	E	2004

into something like

Key	Name	Year
1	A	2000
2	B	2002

and next to it should be a table like this:

Key	Name	Year
3	C	2000
4	D	2003
5	E	2004

Any ideas? 

A few ideas are in my head like a measure which would only show the first x entires and then the rest. Or I have to create several tables in PowerQuery which I do not really want to do. 

Thanks for the help. 

Best

[v-yadongf-msft]

Hi @tmul ,

Is this the result you want?

Please create 6 new columns like below:

Key1 = SWITCH(
    TRUE(),
    'Table'[Key] = 1,1,
    'Table'[Key] = 2,2,
    BLANK()
)

Name1 = SWITCH(
    TRUE(),
    'Table'[Key] = 1,"A",
    'Table'[Key] = 2,"B",
    BLANK()
)

Year1 = SWITCH(
    TRUE(),
    'Table'[Key] = 1,2000,
    'Table'[Key] = 2,2002,
    BLANK()
)

Key2 = SWITCH(
    TRUE(),
    'Table'[Key] = 1,3,
    'Table'[Key] = 2,4,
    'Table'[Key] = 3,5,
    BLANK()
)

Year2 = SWITCH(
    TRUE(),
    'Table'[Key] = 1,2000,
    'Table'[Key] = 2,2003,
    'Table'[Key] = 3,2004,
    BLANK()
)

Name2 = SWITCH(
    TRUE(),
    'Table'[Key] = 1,"C",
    'Table'[Key] = 2,"D",
    'Table'[Key] = 3,"E",
    BLANK()
)

Create a table visual and put [Key2] into filters pane like below:

Please refer the attached pbix file.

Best regards,

Yadong Fang

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

[amitchandak]

@tmul , refer if this can help

https://www.fourmoo.com/2017/10/31/power-bi-how-to-do-pagination-in-power-bi-reports/