Hide columns in Matrix Like in Excel

[Bibiano_Geraldo]

Hello everyone,

In Power BI's Matrix and Table visuals, there is a significant feature missing: the ability to hide specific columns without affecting the total column. Currently, the Matrix visual provides Include and Exclude options, but as the names suggest, these options completely remove the selected column(s) from the visual. This also impacts the total column since the excluded data is no longer considered in the calculations.

What I propose is an enhancement that allows us to hide specific columns or sub-columns, similar to how it works in Excel. In Excel, when we hide a column, the totals remain unaffected because the data is only hidden from view—not excluded from the calculations.

Example Scenario:

1 - Consider a table where some columns display percentage measures, and you want to hide these percentage columns while keeping the total column visible and accurate.

2- It would be very useful to have an easy option to hide these columns without altering the data in the totals, like the "Hide" functionality in Excel.

3- After hiding the selected columns, the table should look like this:

This feature would greatly enhance usability and allow for more flexibility in presenting data in Power BI.