Hide, Resize and Reorder columns in Power BI matrix

by Inforiver | Oct 29, 2021 | ,

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.

Manage columns in your Power BI report

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:

  • When you want to temporarily turn off some measures (e.g., related to costs) to focus on one or two measures (e.g., sales and profitability), or
  • you have assigned some fields from your data model solely for the purpose of using them in calculations - and you do not want to display them, or
  • you have broken down a large formula into a series of interim calculations (i.e. measures), and you do not want to display all of them;

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.

Advanced Settings

Finally, when you press the gear icon from on the top right, you will see a more detailed window as shown below.

Manage columns in your Power BI reports

From this window, you can

  • override the default aggregation for each measure at the visual level,
  • set default widths for each measure, and
  • click on the gripper icon in the far right and drag it up or down to change the column order.

Note that when you override default aggregation, Inforiver will use only the data presented to the visual.

Auto-adjust column width in the Matrix

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:

  1. Choosing ‘Fit to Content’ or ‘Fit to Header’ resize the columns to respectively fit its contents or column header  
  2. ‘Best Fit’ icon from the toolbar auto-adjusts both rows and columns that optimizes real estate
Set custom column width in Power BI table/matrix

Related Power BI Ideas:  Hide/Show Column on Table 

For more such quick snippets on Inforiver, click here.


Inforiver Logo
About Inforiver!

Inforiver delivers the fastest way to build collaborative reports in Power BI through a seamless low-code / no-code experience. The product is developed by Lumel Technologies, which has a decade of experience in building visualization products including ValQ, xViz and BI Hub.
ValQ
BI Hub
xViz
5920 Windhaven Pkwy, #130
Plano TX 75093
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram