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

DataBank's avatar
DataBank
Helper III
4 years ago

Hellow everyone, i heed ur help how to conditionally hide the column in power bi matrix,

1>> in top visaul whenever im place arr then u can see the red highlited arr going to repeat across the month

2>> but i dont want to repeat the column and its value as i have solve this issue by using Tabular Editor and but i want to resolve this issue with using Tabular Eiditor