Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago
Solved

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:...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

amitchandak's avatar
amitchandak
Super User
2 years ago

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 ?