What happens to data when you pivot columns in Power BI?

easy📝 Conceptual Q1 of 15

Power BI - Data Cleaning with Power Query

ARows become columns to summarize data

BColumns are deleted permanently

CData is sorted alphabetically

DNew rows are added without changing columns

Step-by-Step Solution

Solution:

Step 1: Understand pivoting concept
Pivoting changes rows into columns to reorganize data for analysis.
Step 2: Identify effect on data structure
It transforms row values into new column headers, summarizing data.
Final Answer:
Rows become columns to summarize data -> Option A
Quick Check:
Pivoting = Rows to columns [OK]

Quick Trick: Pivoting flips rows into columns for easier analysis [OK]

Common Mistakes:

Master "Data Cleaning with Power Query" in Power BI

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More Power BI Quizzes