Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to show hide a visual when the visual error occurs

Hi Team,   We have OLS(object level security) implimented in our report and when an user who doesnt have access to certain object logs in, the visual will show an error message like below.   Inst...
  • Anonymous's avatar
    Anonymous
    5 years ago

    I found an alternative solution for this.  below is what i did.

    1.  I called the same AD group another time and adding into the datasource and creating relationship (getdata --> AD group). this is the same AD group from where the OLS is getting applied

    2.  Created a DAX measure in my table to check if the user from table1 is available in AD group table, if yes, give color "#FFFFFF00" else "red". 

    3.  Added a rectangle shape on top of the visual which gives error when OLS is applied. 

    4.  For this rectangle shape I added the background with function... and added this dax there which changes the color based on the dax.

     

    Hope that helps for those looking for an alternative.