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
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?
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.
can you share me the .pbix file
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.
you should share the .pbix file for help and learning. By givin screenshot its not the solution.
