How to set-up Visual for restricted viewing access ?

[uidn1574]

Hi all, 
I have a requirement for visual and filter page, where 

1. Location responsible - Can view his location and all location overview visual.
2. Location responsible - Can Filter/Slice Under his location only. (Cannot look/slice into Business Area or Sub-type)
3. Default - gives a complete/global view on first page.

Any, help or idea on how to tackle this is appreacted.

 Sample Data:

Location	Business Area	Sub-type	Value
Loc - 1	BA - 1	ST -1	12
Loc - 1	BA - 1	ST -2	13
Loc - 1	BA - 3	ST -1	14
Loc - 1	BA - 3	ST -2	15
Loc - 2	BA -1	ST -1	16
Loc - 2	BA - 3	ST -2	17
Loc - 3	BA - 3	ST -3	18
Loc - 3	BA - 3	ST -1	19
Loc - 4	BA - 1	ST -2	20

Sample view of Visual ;

[uidn1574]

hi Gao, 
never say Sorry 😲. i'm looking for solution And you provided an way. 
Thanks anyway.
Let's see if someone else has anything else to say.

Regards
uidn1574

[uidn1574]

Hi Gao,
Thanks for replying. 

For point 2 only RLS works completly fine.

I was thinking more on line of Duplicating data source + some magic (bookmark or combination)
for point 1/3 along with it. But could not create any model. Any sugesstion on this line.

Regards 
uidn1574

[v-cgao-msft]

Hi @uidn1574 ,

Sorry for my poor knowledge, I can't give any suggestions.😑

For points 1 and 3, the slicer does not currently support visible but unavailable settings like this.

Best Regards,
Gao
Community Support Team

[v-cgao-msft]

Hi @uidn1574 ,

RLS can be used to achieve the second point: Location responsible - Can Filter/Slice Under his location only. (Cannot look/slice into Business Area or Sub-type)

Row-level security can be used to restrict data access for given users,Filters restrict data access at the row level. Please refer this:

Row-level security (RLS) with Power BI

For needs like 1 and 3 points. I would suggest you submit an idea in Power BI Ideas: Ideas

It’s a place where the product group collects suggestions from users to improve the features of this product. Thanks in advance!

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data