cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

How can i hide Column ?

Hello ;
I wish to hide the column of Client perdu of Budget N of this matrix
.


How I can I do it
?matrix.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User VII
Super User VII

Re: How can i hide Column ?

You can do this my create a another column:

 

in my example, i want to hide revenue where currency is CAD, so I created another field using DAX expression, if hope you can use the same logic 

 

My Display Revenue = if(Sales[Currency]="CAD",BLANK(), Sales[Revenue])

and now you can see the output, My Display Revenue is blank for currency "CAD" but it shows for other currencies

hide1.PNG






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

21 REPLIES 21
Highlighted
Community Champion
Community Champion

Re: How can i hide Column ?

@Betissa

1) If you want to hide this Column only under Budget N but display it under the others - you can't do this like you would in Excel.

 

2) You may be able to achieve this result by writing separate Measures to duplicate each column - but I don't know if this would be worth the time!

 

3)You can also always cover it up with some other shape/visual to hide it! (Not a good choice since you have formatting)

 

4) But what you should probably do - go to the Column Header on the right side and just drag to the left as if to make it smaller!

It should disappear!

 

Good Luck! Smiley Happy

Highlighted
Super User VII
Super User VII

Re: How can i hide Column ?

You can do this my create a another column:

 

in my example, i want to hide revenue where currency is CAD, so I created another field using DAX expression, if hope you can use the same logic 

 

My Display Revenue = if(Sales[Currency]="CAD",BLANK(), Sales[Revenue])

and now you can see the output, My Display Revenue is blank for currency "CAD" but it shows for other currencies

hide1.PNG






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Highlighted
Helper I
Helper I

Re: How can i hide Column ?

@parry2k@Sean
Your answer was very useful for me
Thanks a lot

Highlighted
Frequent Visitor

Re: How can i hide Column ?

yes, but if you pin the visual to a dashboard the column unhides itself!

 

Highlighted
Post Partisan
Post Partisan

Re: How can i hide Column ?

Hi,

 

I Have 3 column but I want hide second column "CTY" in my pbix file shared https://drive.google.com/open?id=0BxreilNC4AvsVGFRUFhWNUNXQW8

 

How will I do that if you help me on my pbix file and share with me.

 

Thanks

Aamir

Highlighted
Super User VII
Super User VII

Re: How can i hide Column ?

Hey @mdaamirkhan

 

Sorry I'm not clear about your request, do you want to complete hide this column or on some condition. 






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Post Partisan
Post Partisan

Re: How can i hide Column ?

I mean both way

Highlighted
Super User VII
Super User VII

Re: How can i hide Column ?

no idea what you mean by both way. i think you have to provide more details with expected result. just saying hide the column is not enough to provide help. sorry about that.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Highlighted
Post Partisan
Post Partisan

Re: How can i hide Column ?

in ther previous messages  you hide a culomn rite. So I want to hide a column "CTY" from Matrix/Table as there are 3 column.

 

Is there any way to hide and unhide a column conditionally. 

Helpful resources

Announcements
Meet the 2020 Season 2 Power BI Super Users!

Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

July 2020 Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

Featured Data Story of The Month

Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

Power BI Dev Camp - Developing with .NET Core

Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors