Slicer Filter disable or enable for users

[azaterol]

Hi all,

is it possible to enable the slicer-date for some users and disable for others?

So if an end user here "Employee" see his report he shouldn't be able to change the date.

Otherwise is maybe the CEO is the end user, he should be able to change the date for the slicer. 

Employee:

CEO:

Sincerely, thank you

[v-henryk-mstf · Accepted solution]

Hi @azaterol ,

Based on your description, it doesn't seem to be possible to customize the use of the filters based on user switching. Features like OLS,RLS can only limit the data that users can access.
My suggestion is to create a bookmark and put the displayed dates into the card visual on the user page.

You can read related blog as below:

Object-Level Security (OLS) is now generally available in Power BI Premium and Pro! | Microsoft Powe...

Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Docs

If the problem is still not resolved, please point it out. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Shishir22]

Hello @azaterol ,

Please try implemeting Object Level Security on your Date Table. 

https://www.youtube.com/watch?v=PAX5GP9SkTA

https://www.sqlbi.com/tv/exploring-object-level-security-in-power-bi-unplugged-13/

Please mark it as solution if it resolves your issue. Kudos are also appreciated.

[azaterol]

Hello Shishir,

its not that what I looking for. 

If the role is "employee" the table should not be disable. It just he has no permission to change the date, as a "employee".