Inforiver

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
Inforiver Logo
IBCS Certified
Power BI certified
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
Headquarters
5920 Windhaven Pkwy, #130
Plano TX 75093
ValQ
xViz
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram