Forum Discussion
How to visualize data from a long term plan consisting of multiple spreadsheets
vchan,
You would need to unpivot columns in each table, and append cost tables in a single table, then create relationship between the appended table and the EBITDA table. For more details about how to create the two charts, please review attached PBIX file.
Regards,
Lydia
Hi Lydia,
Thank you so much for taking the time to respond to my questions. I was hoping there would be a solution that does not involve "unpivoting" or normalization of the costs tables, and still would allow me to visualize the data in ways similar to the following:
![20181011 Sample visualization]("H:\Other Content\Data\Work\Archives\2018\Analytics\20180910 Pjt 26 Digitization potentials for CPC\20181011 Sample visualization.PNG")
where the Costs and EBITDA are the average Costs and average EBITDA of each Asset over 2019-2021. So far, I could only do this by first calculating the 2019-2021 averages into a table. Any instructions that could show me how I could save this first step, perhaps by joining the Costs tables in some ways, would be greatly appreciated. Thanks much in advance.
