Pivots & data tools

Why build a pivot on a Table?

Structured references expand automatically, so new rows are included on refresh.

What does Show Values As do?

Provides % of total, running total, rank and difference calculations without helper columns.

How do you link one slicer to several pivots?

Report Connections, provided the pivots share a cache.

Which pivot feature needs the Data Model?

Distinct Count as a value summarisation.

What does Power Query From Folder do?

Applies one transformation to every file in a directory and appends the results.

Unpivot — what is it for?

Turning wide data (one column per month) into tall attribute/value rows.

Connection Only load — why?

Keeps a staging query in memory without writing rows to a worksheet.

Worksheet row limit?

1,048,576 rows. The Data Model holds far more because data never lands on a sheet.