How to create Display Table/Matrix with Date Year in columns and results in rows below

[Willie_C]

Hi everyone,

I am a bit new to Power Bi, so I was would really appreciate the help.

Essentially, I am attempting to create a Display Table or Matrix that has Month Year in the columns and a list of the results for each column respectively below each header. Doing so would allow monitoring of who enrolled in what month/year for academic records like the example below. Please note that this is mock data. 

Desired View in Power Bi Visual 

Jan 2023	Feb 2023	Mar 2023	Apr 2023
Eric van der Woodsen	Dan Humphrey	Serena van der Woodsen	Jenny Humphrey
Spencer Hastings	Chuck Bass	Nate Archibald	Emily Fields
	Blair Waldorf	Aria Montgomery	Tyler Blackburn
	Lucas Gottesman	Hanna Marin
	Mike Montgomery

My data is structured as seen below in the source and in Power Bi.

Data Layout

Name	Age	Classification	Enrollment Date
Dan Humphrey	19	Sophomore	2/22/2023
Serena van der Woodsen	20	Sophomore	3/10/2023
Chuck Bass	21	Junior	2/20/2023
Blair Waldorf	20	Sophomore	2/10/2023
Nate Archibald	20	Sophomore	3/5/2023
Eric van der Woodsen	18	Freshman	1/25/2023
Jenny Humphrey	18	Freshman	4/3/2023
Aria Montgomery	19	Sophomore	3/17/2023
Emily Fields	19	Sophomore	4/1/2023
Spencer Hastings	20	Sophomore	1/15/2023
Hanna Marin	20	Sophomore	3/31/2023
Lucas Gottesman	21	Junior	2/1/2023
Mike Montgomery	18	Freshman	2/19/2023
Tyler Blackburn	21	Junior	4/2/2023

Again, any assitance would be appreciated 🙂 

Thank you!

[Willie_C]

Hello @Anonymous ,

Thank you for the response. Is it possible to present the data without age and simply show the names of enrolees each month? 

The data provided is sample/mock data. Unfortunalty, it looks like I don't have the option to attach a file in the forum.

[Anonymous · Accepted solution]

Hi @Willie_C ,

This will cause data disorder.

For example, in January there are two data for Eric van der Woodsen and Spencer Hastings. If they are not identified by age, then only the first name will appear in the value field.
You can also try changing the font of the data under row to white.

Best Regards
Community Support Team _ Rongtie

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

[Anonymous]

Hi @Willie_C ,

I have created a simple sample, please refer to it to see if it helps you.

Put the age on the row.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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