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
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.