Forum Discussion
Solved
Data Layout Advice
Hi, I am pulling a lot of data into Power BI from Online Excel sheets, and am finding it hard to lay the data our in a way that Power BI can use it. hopefully this is just be being new...I am hop...
Hi,
In the Power Query Editor, right clock on the first 2 columns and select "Unpivot Other Columns". Split the attribute column into 2 using space as a delimiter. The data should not become usable.
Hi foodd
Apologise, and thanks for the reply.
An example excel file is here: https://filebin.net/qmhliy5npb7x9jpl
I guess all I am looking for really is how I can load this into PowerBi and be able to add a week date filter so that I can show one week at a time.
Thank you