Forum Discussion
Solved
how to structure excel data
Hello, I am new to PowerBI and have a question re pulling data in from an Excel spreadsheet I am using, and how i am best to structure the data in excel to get BI to read it correctly. Situat...
i have figured out how to spilt the devisions up by silo, it is how the feilds are arranged, but has to be on different graphs.
e.g. with the detailed one i have put "Silos" in the legend.
It would be great if someone knew a method of being able to put it together into the one graph
Hi,
A good start is to transform the dataset into a 3 column one - Silo, Division and Amount. This can be done in the Query Edior using "Unpivot other columns".