Inforiver
LoginTry for FREE

Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

The fastest way to perform pivot analysis 
in Power BI

Excel-like pivot analysis in Power BI

Expand/collapse enabled hierarchies

Expand collapse hierarchies in rows & columns manually or to a specific level​

Layout options​

Leverage excel-like layouts such as classic, stepped, outline and more​

Values on rows or columns​

Show measures on rows or columns using the pivot mode​

Reorder rows and columns​

Click-and-drag to reorder rows and columns with ease​

Configure totals & subtotals​

Change the way in which totals, and subtotals are positioned in the visual​

Custom aggregations​

Define aggregations for totals and subtotals at the visual-level without using DAX​

Group rows & columns​

Create row and column hierarchies at the visual level​

Advanced filtering

Filter values in each column as you can do in spreadsheets using the KPI Explorer​

​Insert quick formula columns​

One-click options to insert columns such as % contribution to grand total, running total, ranking within group​

Featured Blogs

Expand/collapse column hierarchy in Power BIManage totals & subtotalsGroup rows or columns in table / matrix reports in Power BI

Highlights

1. Expand/collapse enabled hierarchies

Expand/collapse row and column hierarchies to view all levels of data at once or specific levels without the need to drilldown​

Expand/collapse enabled hierarchies

2. Layout options

Inforiver offers flexible excel-like layouts such as classic, stepped, outline and more​​

Layout options​

3. Values on rows or columns​

Show measures on rows or columns using the pivot mode. Pivot mode can be applied to hierarchy, outline, table and stepped layouts

Values on rows or columns​

4. Reorder rows and columns​

Rearrange and move around rows and columns using a click-and-drag action​

Reorder rows and columns​

5. Configure totals & subtotals​

Turn on/off or change the positions of the totals and subtotals using a no-code interface. Inforiver also provides a split subtotals option

Configure totals & subtotals​

6. Custom aggregations​

Define aggregations such as sum, average, min, max etc., for totals and subtotals at the visual-level without using DAX​

Custom aggregations​

7. Group rows & columns​

Create row and column hierarchies at the visual level just as you are used to doing in spreadsheets. When you group rows, the subtotal values are calculated automatically. Inforiver also provides auto-grouping of rows based on ABC classification

Group rows & columns​

8. Advanced filtering​

Filter values in columns, rows and measures using the KPI Explorer. Inforiver also provides nested and/or filtering

Advanced filtering
Advanced filtering

9. Insert quick formula columns​

Insert columns such as % contribution to grand total, running total, ranking within group in just a single click​

Insert quick formula columns​

10. Sorting columns​

Sort columns from smallest to largest or largest to smallest

Sorting columns​

Looking for more?​

Explore how you can create visual calculations in Power BI

Continue

Get Inforiver brochure

Maximize your business potential with Inforiver's paginated reporting, data entry, planning & budgeting capabilities
Download now
Inforiver

Inforiver helps enterprises consolidate planning, reporting & analytics on a single platform (Power BI). The no-code, self-service award-winning platform has been recognized as the industry’s best and is adopted by many Fortune 100 firms.

Inforiver is a product of Lumel, the #1 Power BI AppSource Partner. The firm serves over 3,000 customers worldwide through its portfolio of products offered under the brands Inforiver, EDITable, ValQ, and xViz.

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram