Show same report page but with different Filter applied

[TimWend1235]

Hi there!

I have created a report page in Power BI Desktop which merges all data from different company locations into one visualisation.

This looks great, but is not suitable for comparing those different locations next to each other. I currently have a filter visual allowing me to filter onto each and every location on its own - based on row level security. Meaning: I have users that are able to view 30 locations, then some that are only able to view 2/3. No user is able to see all 100 locations at once.

Now what I need is: a way to dynamically display all of the locations each user is allowed to see next to each other in this specific report page.

I am glad for any Idea you might have.

Big thanks in advance

[v-jayw-msft]

Hi @TimWend1235 ,

You have already applied RLS on dataset, that means the dataset was already filtered on data level.

If you want a user to see data that doesn't belong to him/her, then you can only redefine a new role for him/her.

Best Regards,

Jay

[TimWend1235]

Hi jay,

i think i wasnt clear on what the problem is, sorry.

The problem is not within RLS, each user is able to view report page with according locations.

But I want to duplicate the report page for each available location.

Hope this clarifies.

Best regards

Tim