cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

hiding columns in Matrix

Hi there,

 

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?

 

Thank you

 

Capture.PNG 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

 

Capture.PNG

View solution in original post

7 REPLIES 7
v-frfei-msft
Community Support
Community Support

Hi @Anonymous,

 

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

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

Thank you Frank, isnt completely what am looking for but thats very close to it. Thanks once again 

Hi @Anonymous,

 

Does that make sense? If so, kindly mark my answer as a solution to close the case.


Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

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.

 

Capture.PNG

Hi,

I have similar situation-want to hard hightlighted in yellow color column. Want to see total. I try to follow your solution but lost. 

ABC11_0-1651088800917.png

 

under which categary I should go for "turning off word wrap " and dragging field

ABC11_2-1651089076745.png

Please

Thanks

 

Just a note to say thank you.  This solved a issue that was driving me insane

StuartSmith
Impactful Individual
Impactful Individual

Nice little workaround with the hiding of the column. 👍  Helped me out.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!