cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Betissa
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

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
Sean
Community Champion
Community Champion

@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

When dragging the column I want to hide in order to make it smaller, I end up making all my cells disproportionately larger than they should be. My goal is to hide a column that I do not want to show up in my final table, but I want my data to be sorted by this column. Please advise.

 

 

When dragging the column I want to hide in order to make it smaller, I end up making all my cells disproportionately larger than they should be. Please advise. 

When I try to shrink the width of the column the height of the rows increases. How can I shrink in width without increasing the height of the rows?

Thanks in advance

Haider121
Frequent Visitor

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

 

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

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.





I mean both way

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.





Newt98
Frequent Visitor

Assume we have a requirement to display Actual, Target, Actual/Target % and Stock. This needs to be displayed/compared for MTD vs YTD where in YTD, we do not need to display the Stock. In this case, how would we hide the field 'Stock' for YTD whereas show it for MTD?

didnt get your point if you share one sample report it will be good

More details:

Table Structure - 

Segment | Model | StockType | PeriodType | Actual | Target | Stock

 

I want it arracnged in the below format. 'TA_Calc' is a simple calculation as % of Actual/Target. Now, the measure 'Stock' applies only to MTD Period Type while not of YTD. So I would like to hide the column 'Stock' when Period Type is 'YTD'.

 

I have tried another way, where I unpivoted these fields, where I get an 'Attribute' and 'Value', in this scenario, I am able to 'Exclude' the Stock, BUT, the subtotals for the calculated field 'TA_Calc' are not using the formula 'Actual/Target'. 

 

I need a solution on how I can get the below visualization with the expected output as suggested above.

Capture.PNG

can you share me the .pbix file

I'am sorry I cant. But I can share any more details you may need or I'm open to any suggestions like using a different visual etc.

you should share the .pbix file for help and learning. By givin screenshot its not the solution.

ok

 

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. 

any update?

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

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.