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

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

Hi,

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.

1 REPLY 1
Highlighted
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,

Teige

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors