Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Womb

Good afternoon, I am asked to recreate the following table:

This would be my table:

YearEnterpriseIndicator31/01/202028/02/202031/03/202030/04/202031/05/202030/06/202031/07/202031/08/202030/09/202031/10/202030/11/202031/12/2020Index
2022SonySales59912548503237257445690
2022SonyCosts of services506994577868860453172671
2022SonyOther61614052601793326173812
2022SonyPersonal Costs381485132861577549260873
2022SonyTransport costs4085597691537145146045684
2022SonyGross Margin303292485814448265411645
2022SonyEBITDA724990287010076883379266
2022SonyEBIT 515176335277179881414937
2022SonyEBT7463866988625894422908
2022SonyTaxes63100812560867319266689
2022SonyNet Income628770552631118015946910010
2022SonyProvisions6127398746524864854629911
2022SonyFinancial result9880703395725519399744

12

After some transformations, which in my opinion are convenient, the table in power BI would look like this:

And the only decent array I manage to create in Power Bi would be this:

But if I include the indicators in the rows section, it doesn't look the way I'd like.

I have tried to put a copy of the table and establish a relationship between the two, so that I can have a column of indicators as I have in the original table without performing any transformation, and thus in the matrix I can have the column of indicators. I'd look something like this:

But when I add the indicator values from either table, I don't get what I'm looking for. Additionally, I attach the data that indicates to me in the visualization panel, first the transformed table, and then the original table:

  

  

I hope you can answer my question.

2 Replies