Skip to main content
Don’t miss what’s next at Microsoft Ignite
Don’t miss what’s next at Microsoft IgniteGet direct access to the people, products, and expertise behind Microsoft technology, with opportunities to ask questions, build skills, and learn alongside the community.
Register now
Microsoft
separator
https://catalogartifact.azureedge.net/publicartifacts/craic-llc.pivotview-33dd7c16-d321-4129-ac2e-c69e2d657887/image0_storelogo300x300.png

PivotView: Excel-Style Pivot Tables

by CRAiC LLC

Download SampleInstructions

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
English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Us Privacy & Cookies Terms of Use About our ads Manage cookies