Forum Discussion
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
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! :smileyhappy:
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
Hello Everyone,
I am having the trouble in hiding the columsn in a matrix based on slicer selection. I mean if current month is Yes then it should show Jan column in the matrix visual and if its No then it should show till december itself in the matrix visual. Does anybody have the solution for this.
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.
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
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.
