How can i hide Column ?

[Betissa]

Hello ;
I wish to hide the column of Client perdu of Budget N of this matrix.

How I can I do it ?

[DataBank]

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

[Sean]

@Betissa

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!

[draja01100]

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. My goal is to hide a column that I do not want to show up in my final table, but I want my data to be sorted by this column. Please advise.

[draja01100]

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. 

[yamenmarquez]

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

[Haider121]

yes, but if you pin the visual to a dashboard the column unhides itself!

[mdaamirkhan]

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

[parry2k]

Hey @mdaamirkhan

Sorry I'm not clear about your request, do you want to complete hide this column or on some condition. 

[DataBank]

How to Hide Column Conditionally in power bi Matrix

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

[mdaamirkhan]

I mean both way

[parry2k]

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.

[Newt98]

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?

[mdaamirkhan]

didnt get your point if you share one sample report it will be good

[Newt98]

More details:

Table Structure - 

Segment | Model | StockType | PeriodType | Actual | Target | Stock

I want it arracnged in the below format. 'TA_Calc' is a simple calculation as % of Actual/Target. Now, the measure 'Stock' applies only to MTD Period Type while not of YTD. So I would like to hide the column 'Stock' when Period Type is 'YTD'.

I have tried another way, where I unpivoted these fields, where I get an 'Attribute' and 'Value', in this scenario, I am able to 'Exclude' the Stock, BUT, the subtotals for the calculated field 'TA_Calc' are not using the formula 'Actual/Target'. 

I need a solution on how I can get the below visualization with the expected output as suggested above.

[mdaamirkhan]

can you share me the .pbix file

[Newt98]

I'am sorry I cant. But I can share any more details you may need or I'm open to any suggestions like using a different visual etc.

[mdaamirkhan]

you should share the .pbix file for help and learning. By givin screenshot its not the solution.

[mdaamirkhan]

ok

[mdaamirkhan]

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. 

[mdaamirkhan]

any update?