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

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. 

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

        Sorry Anonymous didn't explain well, I assumed you have amount field you want to hide, so this new calculated column will give blank value and then use calculated field in your report instead of your original field