https://catalogartifact.azureedge.net/publicartifacts/craic-llc.pivotview-33dd7c16-d321-4129-ac2e-c69e2d657887/image0_storelogo300x300.png
PivotView: Excel-Style Pivot Tables
Excel-style pivot tables in Power BI: drag, drop, drill, subtotal, and format. Free for 100 rows.
Build real pivot tables in Power BI, the way you already know from Excel.
PivotView gives report authors and everyday business users a genuine pivot-table experience inside Power BI. Drag fields into Rows, Columns, and Values, expand and collapse hierarchies, add subtotals, filter and sort, all directly in the visual, with the polish and keyboard-friendly feel of a spreadsheet.
Every feature is included free for pivots up to 100 rows. That makes it easy to evaluate PivotView on your own data, or to run smaller reports forever at no cost. A Pro license removes the row limit for your whole dataset.
Why report builders love PivotView:
- True drag-and-drop pivoting: rearrange Rows, Columns, and Values on the fly, right in the visual. Viewers can explore without editing the report.
- Excel-familiar layouts: Compact, Outline, and Tabular; subtotals on top or bottom (or off per field); blank rows between groups; repeat item labels; grand totals that always tie out.
- Fast with big data: a one-pass aggregation engine handles hundreds of thousands of rows smoothly, and loads beyond Power BI's initial data window on demand.
- Rich filtering and sorting: per-field checkbox filters with search, date and numeric range filters, Top N, hide-zero rows, and per-level sorting by label or value.
- Show As calculations: % of grand total, % of row/column, running totals, and more, without writing DAX.
- Conditional formatting: heatmaps, color scales, and data bars that respect your theme.
- Saved Views: capture complete layouts and switch between them from the toolbar; set a default view for report readers. Viewers can even share their exact view back to the author with a copyable view code.
- Copy to Excel with formatting: one click copies the pivot with headers, themes, number formats, titles, and filter context intact.
- Professional appearance: an Excel-inspired default theme, a full style gallery with Office accent colors and custom colors, smart auto-titles with live filter summaries, an optional "data as of" banner, and high-contrast support.
- Accessible and keyboard-friendly: full keyboard navigation and screen-reader-conscious focus handling.
Licensing made simple:
- Free: every feature above, for pivots up to 100 rows. No sign-up, no time limit.
- Pro: removes the row limit and unlocks the complete experience for your full dataset. A simple annual per-user license purchased directly from CRAiC LLC. Activates in seconds with a license key, fully offline, no account required.
- Enterprise: for organization-wide deployments, Power BI Report Server, offline, and restricted environments. Organization-wide license keys, purchase-order friendly procurement, and priority support. Contact us at dev@zebraanalytics.com.
Support: dev@zebraanalytics.com · https://craic-llc.github.io/
PivotView processes your data entirely inside Power BI. No telemetry, no external calls. Your data never leaves your report.
Visual capabilities
This visual is certified by Power BI
At a glance
https://catalogartifact.azureedge.net/publicartifacts/craic-llc.pivotview-33dd7c16-d321-4129-ac2e-c69e2d657887/image5_screenshot1.png
https://catalogartifact.azureedge.net/publicartifacts/craic-llc.pivotview-33dd7c16-d321-4129-ac2e-c69e2d657887/image1_screenshot2.png
https://catalogartifact.azureedge.net/publicartifacts/craic-llc.pivotview-33dd7c16-d321-4129-ac2e-c69e2d657887/image4_screenshot3.png
https://catalogartifact.azureedge.net/publicartifacts/craic-llc.pivotview-33dd7c16-d321-4129-ac2e-c69e2d657887/image3_screenshot4.png
https://catalogartifact.azureedge.net/publicartifacts/craic-llc.pivotview-33dd7c16-d321-4129-ac2e-c69e2d657887/image2_screenshot5.png