Hello @zoey
Welcome to the Quicksight Community! Thank you for posting your question.
Yes, its possible to do this usecase in Quicksight. There are several Question and Answers provided on the similar usecases in this community, I would recommend you to go over them.
I have attached some of them that could help you, you can also search “RLS” or “row-level security” on the search bar to get more results on the frequently asked questions -
- Action Required: Amazon QuickSight Introduces Rules Datasets Flag for Row Level Security (RLS) Datasets
- Row Level Security with multiple value in Quicksight - #2 by Brett
- Set up row-level security - #4 by Giridhar.Prabhu
- QuickSight RLS Behavior Change: IAM Groups vs Individual User Access
Let me know if this helped you.
Thank you,
Shravya