FlexiPivot

## Overview FlexiPivot is a powerful interactive pivot table visual for Microsoft Power BI that brings Excel-like pivot functionality directly into your reports. With intuitive drag-and-drop capabilities, multiple visualization options, and seamless Power BI integration, FlexiPivot transforms how you explore and present data. **Why FlexiPivot?** Traditional Power BI visuals require pre-configured layouts. FlexiPivot lets your users dynamically restructure data on the fly - dragging fields between rows, columns, and values to discover insights without rebuilding reports. --- ## Key Features ### Drag-and-Drop Interface Intuitive Excel-style pivot table experience. Drag fields to rows, columns, or values areas to instantly restructure your data view. No DAX required - just point, click, and explore. ### Multiple Visualization Types Switch seamlessly between views: - **Tables**: Classic pivot table with subtotals and grand totals - **Bar Charts**: Grouped and stacked horizontal/vertical bars - **Line Charts**: Trend analysis with multiple series - **Area Charts**: Stacked area visualizations - **Scatter Plots**: Correlation analysis - **Pie Charts**: Part-to-whole relationships - **Heatmaps**: Color-coded data density ### Built-in Aggregations Apply aggregations without writing formulas: - Sum, Average, Minimum, Maximum - Count and Count Unique Values ### Power BI Integration - **Cross-Filtering**: Click chart elements or table cells to filter other visuals - **Native Tooltips**: Full support for Power BI tooltip pages - **Format Pane**: Customize colors, titles, and appearance - **State Persistence**: Pivot configuration saves with your report ### Data Formatting Automatically respects Power BI format strings: - Currency symbols (USD, GBP, EUR, JPY, and more) - Percentage formatting - Decimal precision - Thousands separators ### Extensive Customization Options Full control over the appearance of every element: - **Style Presets**: Choose from Default, Professional, Light, or Dark themes - **Table Formatting**: Customize fonts, colors, and backgrounds for headers, values, totals, and grand totals - **Chart Styling**: 8-color customizable palette, title formatting, axis titles with bold/italic/underline - **Pivot Controls**: Customize field tags, dropdowns, and filter popup appearance - **Heatmap Colors**: Custom color schemes for heatmap views --- ## Use Cases - **Financial Analysis**: Quickly slice revenue by region, product, and time period - **Sales Reporting**: Let sales teams explore data by rep, territory, or customer segment - **Operations Dashboards**: Aggregate metrics across departments and locations - **Ad-Hoc Analysis**: Enable business users to answer their own questions - **Executive Summaries**: Present data in both tabular and graphical formats --- ## Compatibility **Supported Environments:** - Power BI Service (Power BI Online) ✓ - Power BI Desktop ✓ **Not Supported:** - Power BI Embedded - Power BI Report Server - Power BI Mobile (limited functionality) FlexiPivot is designed for interactive use in Power BI Service and Power BI Desktop. The licensing validation requires connectivity to Power BI Service. --- ## Licensing ### Free Tier - Up to 20 data rows - All features included ### Licensed Version - Up to 100,000 data rows ---