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
Thanks,
I have added to columns as you suggest and also put a month column.
I have linked this table to Power BI, and have been able to create the below graph.
Do you know how I might be able to filter it etc. so i can also show the breakdown by silo within these 3 devisions? so this graph overal will look the same, but each of the blue bars showing will instead be 5 different colors (for each silo)