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