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

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