Forum Discussion
Hadill
Helper I
Helper IData Cleansing
Hello, I am creating a dashboard on Power BI that reads data from many excel sheets available in a SharePoint site. I understand that the data in the excel sheet should have a specific form/layo...
Hello Hadill ,
You could try to work on it and shape it in power query, check this link to learnabout pivot and unpivot https://databear.com/power-bi-pivot-and-unpivot-columns/
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍
Idrissshatila
Super User
Super UserHello Hadill ,
You could try to work on it and shape it in power query, check this link to learnabout pivot and unpivot https://databear.com/power-bi-pivot-and-unpivot-columns/
If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍