Table visual - split into to or more visuals?

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.