Inforiver delivers a powerful 'Manage Columns' feature that helps you show/hide columns, reorder measures, resize columns by setting default column widths and apply custom aggregations in your Power BI table / matrix reports.
To access this feature, click on the 'Manage Columns' dropdown from the top of the ribbon menu.
Using the check boxes on the right, you can choose to show/hide measures from your report. You may want to hide one or more columns under several circumstances:
In the above image, the icon preceding each measure name shows how that specific measure is displayed. E.g. 2021 Actuals is shown as a bar chart. This is very helpful to figure out where the columns are relatively positioned in the table.
The search feature at the top of this window helps you to find any measures from the list.
Finally, when you press the gear icon from on the top right, you will see a more detailed window as shown below.
In the Display tab, you can
Note that when you override default aggregation, Inforiver will use only the data presented to the visual.
In the Versions tab, you can set/update the versions and perform variance analysis.
Note that, by default, if the data fields are assigned to the AC, PY and PL fields during data mapping, it gets automatically updated.
Finally, there are a couple of additional ways by which you can quickly adjust column width, especially when you have a lot of columns in the report. This can be done directly from the toolbar in three ways:
Related Power BI Ideas: Hide/Show Column on Table
Curious about Inforiver? Read why Matt Allington (Self Service BI Expert + Microsoft MVP) , Excelerator BI prefers Inforiver over the Analyze in Excel capability that comes with Power BI for ad-hoc analysis.
Inforiver is the fastest way to do everything in Power BI. It enables citizen developer productivity and unleashes true self-service with our intuitive and interactive no-code data app suite for Microsoft Power BI. The product is developed by Lumel Technologies Inc, who are #1 Power BI Visuals AppSource Partner serving over 2,000+ customers worldwide with their xViz, Inforiver, and ValQ offerings.