Forum Discussion
Solved
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 ?
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
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.
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?