From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Transposing data

Transposing data

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Transposing data

“

- Think of each cell in a table as a value with pivot coordinates referencing row and column dimensions. When we transpose a table, we change the data table shape but not its pivot coordinates as the rows become columns and the columns become rows. Let's use the NOAA PDF Power BI file connection we created earlier to connect to a PDF file. We can use this data table, the one query in it, to test out how the transpose functionality works. The PDF file we see here in the data table contacts several unneeded columns and we may find it faster to filter these out by transposing the tables. Notice that we do not see the first row in the headers right now, so let's just transpose it in its current configuration. To do so, we make sure we have the query selected, go to the Transform tab, and we select Transpose. The first row in the fourth column used to be the fourth row in the first column. Let's delete the flag column by…

Contents