Data Restructuring

[Rahp]

Need to structre the traditional horizontal balance sheet & P&L into above given structure in Powerbi 
Like Ennumbers of competitors data, in traditional B/s & P&L.
need to strcuture in 
Major category :Total Liabilities
Category: shareholder's fund 
Sub Category: equity, reseve & Surplus 
Companies : different 
period : last 10 years 22-23,23-24
Amount : Respective amount 
guide for the same as the data will loaded in powerbi 

[v-nmadadi-msft]

Hi @Rahp 

As we haven’t heard back from you, we wanted to kindly follow up to check if the suggestions  provided by the community members for the issue worked. Please feel free to contact us if you have any further questions.

Thanks and regards

[v-nmadadi-msft]

Hi @Rahp 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @Rahp 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[v-nmadadi-msft · Accepted solution]

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

[amitchandak]

@Rahp , Need more information, check if this can help 

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU
Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI
https://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e...