Forum Discussion

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
1 year ago

How do I use RLS (or some other way) to show/hide these visuals?

I have uploaded my PBIX file here.   This question is somewhat related to my previous post, but business requirement has been changed, so I am posting this question.   I have these three visuals ...
Need Help
collinq's avatar
collinq
Icon for Super User rankSuper User
1 year ago

Hi JustinDoh1 ,

 

Yes, you can hide entire visuals based on RLS.  Assuming that you have already created the RLS rules and then you can create a DAX measure that hides the visual based on role.

 

Something like this:

HideVisualMeasure = IF(ISUSERINROLE("RoleName"), 1, BLANK())

 

Then, in the visual, do the conditional formatting and use the measure to change the color or the visiblity or whatever settign you desire to make it "hidden"

JustinDoh1's avatar
JustinDoh1
Icon for Post Prodigy rankPost Prodigy
1 year ago

collinq Thank you so much. Great to know.

Is it possible for you to demonstrate/show me on my PBIX file by chance?

  • JustinDoh1's avatar
    JustinDoh1
    Icon for Post Prodigy rankPost Prodigy
    1 year ago

    collinq 

    I would like to follow up on my inquiry (whether you could show me on a PBIX file).

    I tried RLS like below (traditional way), but obviously those three visuals would not do anything.

    I am not sure how you can implement the measure you mentioned on the top. (I just cannot get my head around  😞   / I don't know where it should be placed..) 

     

    What is "ISUSERINROLE"? I thought it is one of name of functions in PowerBI, but I guess not.

     

    Just in case needed, I have uploaded latest PBIX file here.

     

    Thanks.