Forum Discussion
2 Way Table
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?
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Seems possible but no sample data test.
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 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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
