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.
