Forum Discussion

AdenikeElemo's avatar
AdenikeElemo
Regular Visitor
2 years ago

RLS Enabled Report

I have an RLS enabled report based on country filtering. Because the Country slicer is single select, I have to have a default country selected before publishing the report. After all the steps, if f...
Need Help
Tips and Tricks
AdenikeElemo's avatar
AdenikeElemo
Regular Visitor
2 years ago

Thanks, the report already had an RLS based on User's country but when Users want to access the report, the default state of the report which is single select may not be that of the User's country. In that case, s/he sees a blank report before selecting the country for the data to get populated. I thought I can change this behavior such that at the access point, the report will default to User's country data without first experiencing the blank page. I will explore the bookmark.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi AdenikeElemo ,

Have you solved your problem? If so, can you share your solution here and mark the correct answer as a standard answer to help other members find it faster? Thank you very much for your kind cooperation!

 

 

Best Regards

Yilong Zhou

  • AdenikeElemo's avatar
    AdenikeElemo
    Regular Visitor
    2 years ago

    Hi, thanks for asking and, NO, issue is yet to be resolved. All calculations on the report page got filtered at specific country levels and if there is no selection of the country slicer or there is select all, the report will fail. So, I need to figure out how to write the dax code that will change the default country based on user's country but I am not sure if this will work in the Power BI service. Thanks!