Showing results for 
Search instead for 
Did you mean: 
asonee_3530 Frequent Visitor
Frequent Visitor

How to make the default selection of slicer dynamic based on a column with RLS


I've a table product_usage with product_name and used_date columns. And I also have RLS implemented. i.e. a user will only be able to see the products he/she is entitled to.


And the report has a few KPIs (bar charts, pie charts, table etc.) and I have a slicer (dropdown and single select) with values from product_name column. Everything is good till here.  Now the requirement is to have only one product selected by default and the selected product should be based on the latest of used_date column.

I tried implementing similar to how the 'Current Month default slicer selection' is implemented. It works fine without RLS but when RLS is on, i.e. when I view as a user with a specific role, it doesn't work. For the default selection, I'm okay to display it as 'Latest Product' like 'Current Month'.

Any help would be appreciated. Let me know if you need any more details.

Community Support Team
Community Support Team

Re: How to make the default selection of slicer dynamic based on a column with RLS

Hi @asonee_3530 ,

Based on my test, I found that it is not possible to meet this requirement.

Best Regards,


Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)