Forum Discussion

tmul's avatar
tmul
Frequent Visitor
3 years ago

Table visual - split into to or more visuals?

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)

KeyNameYear

1

A2000
2B2002
3C2000
4D2003
5E2004

into something like

KeyNameYear
1A2000
2B2002

and next to it should be a table like this:

KeyNameYear
3C2000
4D2003
5E2004

 

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

Need Help

2 Replies

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support
    3 years ago

    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.