Pivoting columns in Power BI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does pivoting columns mean in Power BI?

Pivoting columns means turning unique values from one column into new columns, summarizing data in a more readable way.

beginner

Which Power BI feature is used to pivot columns?

The Power Query Editor's 'Pivot Column' feature is used to pivot columns easily.

beginner

What is the difference between pivoting and unpivoting columns?

Pivoting turns row values into columns; unpivoting turns columns into rows.

intermediate

Why do we use aggregation when pivoting columns?

Because multiple rows might become one column, aggregation (like sum or average) combines values to avoid duplicates.

advanced

How can you pivot columns using DAX in Power BI?

You can use functions like SUMMARIZE and ADDCOLUMNS to create pivot-like tables, but Power Query is simpler for pivoting.

What happens when you pivot a column in Power BI?

A Unique values in that column become new columns

B Columns are deleted

C Rows are duplicated

D Data is filtered out

Pivoting turns unique values from one column into new columns.

Which tool in Power BI lets you pivot columns easily?

A Report View

B Power Query Editor

C Data Model

D DAX Studio

Power Query Editor has a built-in 'Pivot Column' feature.

When pivoting, why do you need to choose an aggregation function?

A To delete rows

B To rename columns

C To combine multiple values into one

D To filter data

Aggregation combines multiple values that map to the same pivoted column.

What is the opposite of pivoting columns?

A Grouping rows

B Filtering rows

C Sorting columns

D Unpivoting columns

Unpivoting turns columns back into rows.

Which of these is NOT a common aggregation used when pivoting?

A Concatenate text automatically

B Average

C Sum

D Count

Concatenating text is not automatic; numeric aggregations like sum or count are common.

Explain in your own words what pivoting columns does in Power BI and why it is useful.

Think about how a sales report might show months as columns instead of rows.

Describe the steps to pivot a column using Power Query Editor in Power BI.

Remember the 'Pivot Column' button and aggregation choice.