Power BI Default User Filter with No RLS

Hi prasaddn ,

Thank you for reaching out to the Microsoft Community Forum.

Native Power BI slicers don’t support a dynamic default selection based on the logged‑in user (e.g., via USERPRINCIPALNAME()), even though that function works perfectly to conditionally filter visuals/measures. Slicers themselves remain “sticky” last published or last personal selection unless you use bookmarks or a workaround.

Please try below alternative workarounds without RLS.

1. If all users open the same starting view not personalized, you can publish the report with your desired filters, then rely on persistent filters in Service or Reset to default. Or add a Bookmark + Button that resets the page to your chosen default view.

2. Ask each user to select their name in the slicer once, then Save as personal bookmark and Set as default view. Personal bookmarks persist across browsers/devices and don’t need RLS.

3. If you want a default subset like current user’s territories that applies only when slicers are not actively filtering, you can use a calculation group to inject filters until a slicer selection exists.

Please try below links.

Overview of Bookmarks in Power BI Service Reports - Power BI | Microsoft Learn

Set Up Default Filters in Power BI - Microsoft Fabric Community

How to dynamically select the default values we ne... - Microsoft Fabric Community

Please refer below Ideas forum link and upvote the appropriate idea related to your scenario.

Dynamically switch between bookmarks based on sele... - Microsoft Fabric Community

Search - Microsoft Fabric Community

If not we would recommend submitting your detailed feedback and ideas through Microsoft's official feedback channels, such as Microsoft Fabric Ideas. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.

https://ideas.fabric.microsoft.com/ideas/search-ideas/ 

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh