Slicer values with row level security

Hi!

 

I have the following issue. My report is basically driven by a slicer with all customer names, and this works fine for those of us with access to the full data set since we choose customers on the slicer and see the data for each.

 

Now, I want to share the report with actual customers, each of which should obviously only see their data. I can essentially achieve this with Row Level Security, BUT I am facing the following: the customers slicer does not change to have as the only option the one value in the customers table that I allow each role to see, but actually it retains the "last" value the report had for the slicer (although it´s not a valid value for that role!).

 

Example to explain:

- The last value the slicer had was Customer Y (but with full access I can see all other customers in the slicer)

- I change to a role that can only see Customer X... and the charts are all empty because the slicer remains set on Customer Y, whose data this user has no access to. If I display the values in the slicer, I can see it´s only Customer X, but as a user experience is clunky (plus they see other client´s name as they go into the report).

 

By the way, I can experience exactly the same behaviour if I use URL filters (and filter by Customer X); the report is filtered to only data from Customer X, but the slicer keeps the "last value" it had.

 

Any option to "initialize" the slicer properly?

 

Thanks in advance!