Data Restructuring

Hi Rahp ,
Thanks for reaching out to the Microsoft fabric community forum.

If your raw data is in a wide format for example, with each company represented as a separate column you can use Power Query in Power BI to unpivot it. First, load your table into Power BI and open it in Power Query. Then, select all columns except for Major Category, Category, and Sub Category, and click Transform and then Unpivot Columns. If the resulting Attribute column contains combined values you can split it into separate Company and Period columns. This transformation reshapes your data into a long format, making it suitable for use in matrix visuals and easier to analyse across companies and periods.

I hope this information helps. Please do let us know if you have any further queries.
Thank you