Forum Discussion

Betissa's avatar
Betissa
Helper I
9 years ago
Solved

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 ?    
Need Help
  • parry2k's avatar
    parry2k
    9 years ago

    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

Newt98's avatar
Newt98
Frequent Visitor
8 years ago

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's avatar
mdaamirkhan
Post Prodigy
8 years ago

can you share me the .pbix file

  • Newt98's avatar
    Newt98
    Frequent Visitor
    8 years ago

    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's avatar
    mdaamirkhan
    Post Prodigy
    8 years ago

    ok

     

  • mdaamirkhan's avatar
    mdaamirkhan
    Post Prodigy
    8 years ago

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