Section a List/Crosstab

[vini_udenia]

I need to section a list based on values of a column, example want the list to be split up based on values of School. Currently, it all appears as a long list.

Current Output using List / Crosstab:

School          Candidate      Marks   Grade

-----------------------------------------

School A      Candidate 1    20         A

School A      Candidate 2    14         B

School A      Candidate 3    10         B

School B      Candidate 4    22        A

School B      Candidate 5    15         B

School B      Candidate 6    12         B

Desired Output:

School A

Candidate      Marks   Grade

-----------------------------

Candidate 1    20         A

Candidate 2    14         B

Candidate 3    10         B

School B

Candidate      Marks   Grade

-----------------------------

Candidate 4    22        A

Candidate 5    15         B

Candidate 6    12         B

[v-xuding-msft]

Hello @vini_udenia ,

What do you mean, the section of a list? Do you want to create two new tables? If so, you can try this:

School A =
SELECTCOLUMNS (
    FILTER ( 'Table', 'Table'[School] = "School A" ),
    "Candidate", 'Table'[Candidate],
    "Marks", 'Table'[Marks],
    "Grade", 'Table'[Grade]
)

If you don't want to create new tables, you can use a slicer to filter them or use an array visual to display them.

[amitchandak]

@vini_udenia ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.

[vini_udenia]

Hi Amit, I've updated the description