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:
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.
I mean both way
