Forum Discussion
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
23 Replies
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
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
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. Please advise.
When I try to shrink the width of the column the height of the rows increases. How can I shrink in width without increasing the height of the rows?
Thanks in advance
Hellow everyone, i heed ur help how to conditionally hide the column in power bi matrix,
1>> in top visaul whenever im place arr then u can see the red highlited arr going to repeat across the month
2>> but i dont want to repeat the column and its value as i have solve this issue by using Tabular Editor and but i want to resolve this issue with using Tabular Eiditor
