topic Re: Dynamic Slicer selection of First value based on User Profile in Custom Visuals Development Discussion

Dynamic Slicer selection of First value based on User Profile

TK212 — Tue, 27 Sep 2022 18:01:48 GMT

I am trying to get a slicer selection work dynamically based on logged user profile.

For E.x if 'User A' has access to "abc, xyz,edf" and "User B" has access to "rft,kjf,qsc",

When the "User A" opens the dashboard, Slicer should Select one value from "abc, xyz,edf" value and when "User B" opens the dashboard slicer should select one value from "rft,kjf,qsc".

Note:

1. Number of users and values is not fixed.

2. Slicer can select any value based on user Security, no specific order or value.

Values	User Name
abc	User A
xyz	User A
edf	User A
rft	User B
kjf	User B
qsc	User B

Re: Dynamic Slicer selection of First value based on User Profile

lbendlin — Wed, 28 Sep 2022 23:11:39 GMT

Allow users to save their filter choices. These will then be remembered and re-applied when the user returns to the report. Much easier and user friendly.

Re: Dynamic Slicer selection of First value based on User Profile

TK212 — Tue, 11 Oct 2022 12:59:24 GMT

I was able to resolve this issue of Default value Selection from A slicer.

In my case I used a "Chiclet Slicer" to resolve my problem.

This slicer helped me to make dynamic default value selection based on User Security/RLS.

I guess the Other one I can use in this scenario is "Pre-selected Slicer". Since there's was no proper documentation available on web around implementation of it, so I wasn't able to use it. If anyone has idea or link around this particular slicer please share the link below.