Forum Discussion
How to create a table with multiple rows and date column
Hi all
Can someone tell me how to create a table like the one below?
I only know how to create matrix with drilldowns, but the table above is different.
Here is a small data sample:
| Capacity | Demand | Total Facilities | Total Lines | Utilization % | Capacity Excess | Year |
| 1 | 6 | 10 | 2 | 59% | -5 | 2023 |
| 2 | 5 | 10 | 2 | 62% | -3 | 2024 |
| 3 | 4 | 10 | 2 | 64% | -1 | 2025 |
| 4 | 3 | 10 | 2 | 67% | 1 | 2026 |
| 5 | 2 | 10 | 2 | 71% | 3 | 2027 |
| 6 | 1 | 10 | 2 | 70% | 5 | 2028 |
Thanks!
Hi o59393
First you need to go into Power Query and unpivot the table, select the year column and choose Unpivot Columns in the Transform tab, as shown below.
Then click Close & Apply in the Home Tab.
Next, create the Matrix as shown below.
Is this the result you expect?
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
o59393 , Create measures for
Capacity Demand Total Facilities Total Lines Utilization % Capacity and use switch Values to Rows /Show measure on rows
Switch values to row - https://youtu.be/cN8AO3_vmlY?t=11650
But where is the month column in your source data ?Hi o59393
First you need to go into Power Query and unpivot the table, select the year column and choose Unpivot Columns in the Transform tab, as shown below.
Then click Close & Apply in the Home Tab.
Next, create the Matrix as shown below.
Is this the result you expect?
Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
