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
Hey mdaamirkhan
Sorry I'm not clear about your request, do you want to complete hide this column or on some condition.
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.
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?
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
