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?
Solved! Go to Solution.
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
Does that make sense? If so, kindly mark my answer as a solution to close the case.
I have similar situation-want to hard hightlighted in yellow color column. Want to see total. I try to follow your solution but lost.
under which categary I should go for "turning off word wrap " and dragging field
Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.
Put your data visualization and design skills to the test! This exciting challenge is happening now through June10th!
Watch Session 22 Ted's Dev Camp along with past sessions!
Click here to read more about the May 2022 updates!