Forum Discussion

aurelius13's avatar
aurelius13
Frequent Visitor
2 years ago
Solved

RLS/ OLS/ Dynamically Hiding Column Content

Long time lurker, first time poster. I have a tricky RLS(?) question. I'm trying to selectively show content from a column on a visual based on an RLS role. As an example let's use books and plots. I...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    Hi aurelius13 

    How are you applying the filter? Do you plan on using a UserName() or UserPrincipalName() or something else?

    Here I've made a measure that reads the persons email address and show the row if it matches the email:

     

    The email is in the f_book next to the Author name:

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi aurelius13 ,

 

If I understand you correctly, the measure written by SamWiseOwl  already fulfills your needs. You just need to not place the Plot field in the visual object, but only the measure.

 

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

aurelius13's avatar
aurelius13
Frequent Visitor
2 years ago

The measure SamWiseOwl suggested worked great so accepting that as the solution. I just figured out the other piece which is running RLS on the Plot table so the measure only brings in plots that "exists" for any given RLS role. Thanks both!