2 Way Table

[JordanJarron]

Hello everyone,

I am trying to create a two way table in Powerbi,

I have a list of projects with tenure and headcount, 

The table I would like to create would have:

Columns: Tenure by group (<1 year, >1 year etc) 

Row: Headcount <50, >50, >100 etc

The "values" in the table would then be the project names:

	<1 Year	>1 Year	>2 Years
<50 Headcount	Project A Project E Project F		Project D
>50		Project B Project G
>100		Project C

Is that something possible on Powerbi?

[danextian]

Seems possible but no sample data test.

[JordanJarron]

Here to me the important part is the result, the dataset I can rework it, 

You can expect raw data to be like that:

	Headcount	Headcount Group	Start Date	Tenure Group
Project A	30	<50	January 2024	<1 Year
Project B	80	>50	August 2023	>1 Year
Project C	120	>100	July 2023	>1 Year

[Anonymous · Accepted solution]

Hi @JordanJarron 

Thanks for the reply from danextian .

Can you accept the output shown in the screenshot? If so, please refer to the following test.

Sample:

Create a measure as follows

Measure = CONCATENATEX(FILTER('Table', 'Table'[Headcount Group] = MAX([Headcount Group]) && 'Table'[Tenure Group] = [Tenure Group]), [Project], ",")

 Then select the Matrix visualization and place the fields in the corresponding positions.

Best Regards,
Yulia Xu

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