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

Thanks for this. While the formula works to put a dash, the problem is since we can't turn off underlying data they can still export the aggragate and see the salary information.

 

I'm so bummed out about this. :( :( :( :( 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Anonymous In my very first reply I mentioned you about this. You really need to create seperate report and remove this field from data model, there is no other way at this point. If there was ability to pass user name to "power query", it would have been nice. You have to mask your data at source end or remove the column from model.

  • 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. :(