Press "Enter" to skip to content

Converting an Excel Crosstab to Power BI Tabular Data

Leila Etaati breaks out Power Query:

There is a common way of seeing data in Excel as a Matrix format; many data entries look like a matrix in many contexts, from accounting to health data. However, to better analyze data and add more calculations and charts and, in general, get more insight from data, we need to change the matrix data in Excel to a tabular format in Power BI.

For example, below table, we have data about the Deaths from Cancer of Lip, oral cavity, and pharynx by age, sex, and year.

Not surprisingly, Power Query does a really good job at handling this common Excel style.