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
parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

Mitsql it is for row level security, not column level. 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

parry2k Is there a way to make it blank or with a "-" based on a user logged in? They only have read only access to the dashboards.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    parry2k Any ideas would be great please :)

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

      You can add calculated field and check if user has permission to see the value to that field or not and then make that field blank()

       

      here is link for reference 

       

      Just an idea

       

      Amount Hide = 
var r = IF(CONTAINS(UsersTable,UsersTable[login], USERNAME()), 1, 0)
return if(r = 1, Table[Amount], blank())
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Does this get added as a Page Filter Measure? If I have a field that is dragged into a table or matrix visual then that has the review rating, how does this prevent it from being visible? 

         

        I guess what is where I am struggling a bit.