Forum Discussion
HELP with table
Hello, When I upload my sharepoint list to power bi it uploads correctly and in the right order when I look at the query editor BUT when I add the data to the table values or matrix everything is...
MitchM jdbuchanan71 Anonymous is there a way I can organize it by rows?
it should go like this...... even though they are all on the same column I would like to divide the columns by sections like the firs picture. When I add the first column it adds everything at once and it looks all crowded instead of being in sections within the column
POWER
-project 1
- project 2
O&G
-project 1
-project 2
If you add the index column to your PowerQuery and sort by it, the blank rows that break up the sections will be in the correct spot in your table.
Edit: Agree with jdbuchanan71, beat me to it.
