Is it possible to hide columns and keep the total in a matrix. You can do something similar in SSRS by just adding a total at the end of the report.
In the image below, can I hide "Opportunity" in the matrix and keep the total?
Go to Solution.
I was able to solve the problem by turning off word wrap in the matrix setting and dragging the field I wanted to hide.
There is no such an visibility option that supports to conditionally hide/show column in Matrix. One option is to hide or show the values in the column by creating measures, but column headers are still appeared even there is no data. Reference: https://community.powerbi.com/t5/Desktop/How-can-i-hide-Column/td-p/110087
Thank you Frank, isnt completely what am looking for but thats very close to it. Thanks once again
Does that make sense? If so, kindly mark my answer as a solution to close the case.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.