Forum Discussion
hiding columns in Matrix
Hi Frank,
I was able to solve the problem by turning off word wrap in the matrix setting and dragging the field I wanted to hide.
It is called Text Wrap now--the easiest way I'm finding to deal with the new layout is using the search bar in the formatting section.
Hi, thank you for this hint. It is a nice solution for hiding columns and only showing the totals in a matrix visual. But I think this is only a workaround and it would great/nice to have such a feature available in Power BI Desktop in the settings of the Matrix visual. Btw. if you publish the report the to Power BI Service the settings are gone and the columns are all visible again. So at the end this workaround is only usable if you are not publishing the reports to Power BI Service.
Maybe a switch in the setting for "specific columns" named "Only show totals" or something else would be great. If this switch is selected for a specific column the values for this column will not be shown and only the total will be visible then.
Or in the visual settings itself, there we have at the moment three sections:
- Rows
- Columns
- Value
Maybe it is possible to add here two additional sections:
- Sub-Totals
- Totals
By adding the data th these sections you could then control which data is shown in which part of the visual.
I think this could be a very usefull feature request.
Regards,
Frank