Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hiding a column based on a user

Hi Folks,   Just trying to figure out something. There is a small population of users that I need to give access to the reports, but they are not allowed to see a performance rating column. Is ther...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I know. I just wish underlying data could at least be turned off and not just full export. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi parry2k,

 

I hope you are well. I tried doing this again using this formula: 

 

Amount Hide 3 =
var r = IF(CONTAINS(Users,Users[UserName], USERNAME()), 1, 0)
return if(r = 1, Calculate(SUM('Active'[Annual Salary (USD)])), Blank())

 

However, when I add this into my table visual, all the records show up as blank values if the user is not there, not just the one column -- strange. I only want the Annual Salary (USD) column to show up as blank values. Is there something I'm doing wrong? I don't have the users table mapped to my active table because if I do that then only one record shows. 

 

Please and thank you!

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I still can't get this to work correctly. :(