cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
aa2018888 Regular Visitor
Regular Visitor

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

Accepted Solutions
aa2018888 Regular Visitor
Regular Visitor

Re: 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.

 

Capture.PNG

4 REPLIES 4
Community Support Team
Community Support Team

Re: hiding columns in Matrix

Hi @aa2018888,

 

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 other members find it more quickly.
aa2018888 Regular Visitor
Regular Visitor

Re: hiding columns in Matrix

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

Community Support Team
Community Support Team

Re: hiding columns in Matrix

Hi @aa2018888,

 

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 other members find it more quickly.
aa2018888 Regular Visitor
Regular Visitor

Re: 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.

 

Capture.PNG

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 243 members 2,729 guests
Please welcome our newest community members: