Forum Discussion

As_analyst's avatar
As_analyst
Regular Visitor
6 months ago
Solved

Help with Power BI RLS + Default Slicer Behavior

Hi Team, I need some guidance on a Power BI + RLS scenario.   Setup: RLS is applied based on Country access. Example: A user has access to India and Italy. A global country slicer (unrelated...
Need Help
  • Hans-Georg_Puls's avatar
    Hans-Georg_Puls
    6 months ago

    Hi As_analyst , 

    I couldn't find the link to your pbix. Did you miss to  attach it? The pbix would be helpful.

Hans-Georg_Puls's avatar
Hans-Georg_Puls
Super User
6 months ago

Hi As_analyst , thank you for providing the demo file. To get a better understanding of your requirements:

  1. What should exactly happen to the country slicer and the matrix if the reporting country is not part of the set of countries allowed for the user:
    1. All allowed countries are shown in the country slicer?
    2. All allowed counries are shown in the matrix?
    3. Which title and subtitle should be shown?
  2. What should exactly happen to the country slicer and the matrix if the reporting country is part of the set of countries allowed for the user:
    1. Only the selected report country is shown in the country slicer?
    2. Only the selected report country is shown in the matrix?
    3. Which title and subtitle should be shown?

The first case might be confusing to the user. A certain report country is selected but the data from another country is shown. If you really want this behaviour you should at least warn the user.