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
I mean both way
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.
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.
any update?
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?
didnt get your point if you share one sample report it will be good
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.
