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...
Need Help
  • 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.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
5 years ago

Anonymous unfortunately not at this point. I think there are some ideas on this on the ideas forum. Go and vote for the idea.

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡