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
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
At the monthly call, connect with other leaders and find out how community makes your experience even better.
Click here to read more about the May 2022 updates!