Forum Discussion
Transpose in PBI
Hello,
Not sure if this is possible.. But i have a table with stores in rows and products in column, and each row below the product would show sales for the stores that are in rows. I wanted to insert each product from the columns into a single column, so the store would duplicate to multiple rows (1 per product) and the product sales would show on next column. See example:
FROM THIS
TO THIS
So in the example, it shows "STORE 1" being duplicated to accommodate the products that went from columns into the rows. If needed i can send the detailed file.
Hello, do this in power query:
1 Select the Geogrpahy column,
2 Transform>>>Unpivot other columns
3 Close and load.
Cheers,
1 Reply
- samdthompsonMemorable Member
Hello, do this in power query:
1 Select the Geogrpahy column,
2 Transform>>>Unpivot other columns
3 Close and load.
Cheers,