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

parry2k's avatar
parry2k
Super User
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

Betissa's avatar
Betissa
Helper I
9 years ago

parry2kSean
Your answer was very useful for me
Thanks a lot

  • v-uprav's avatar
    v-uprav
    Frequent Visitor
    8 years ago

    Hello Everyone,

    I am having the trouble in hiding the columsn in a matrix based on slicer selection. I mean if current month is Yes then it should show Jan column in the matrix visual and if its No then it should show till december itself in the matrix visual. Does anybody have the solution for this.