Forum Discussion

ericjo's avatar
ericjo
Helper III
1 year ago

SLICER default settings in reports with RLS.

I would like to set the SLICER default in the report with the RLS, but I would like to thank you for the function.   Name Dept Scope of Authority Default Slicer Eric president All HR ...
General Comment
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ericjo ,

 

The solution provided by grazitti_sapna is feasible, can you provide relevant screenshot information as well as test data and describe it?

 

DefaultSlicerValue = 
VAR CurrentUser = USERNAME()
RETURN 
MAXX(
    FILTER(
        'UserTable', 
        'UserTable'[Name] = CurrentUser
    ), 
    'UserTable'[Default Slicer]
)

 

 

Best Regards,
Adamk Kong

 

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

ericjo's avatar
ericjo
Helper III
1 year ago

The provision of the provision was confirmed whether the RLS worked functionally.
What I wanted was whether the default selection of Slicer was possible in addition to the RLS function.
1) In the case of ERIC, there is all permissions, but the slicer must be selected by default.
2) If TOM is connected, the slicer must be selected by default.
3) If it is JOSH, 'R & D' should be selected by default.

 

<DATA>

<Eric RLS >

<Josh RLS>

The 'Default Slicer' column was designated as a slicer and set to a single selection.
The selected 'HR' is selected when setting 'Single Selection'. In this case, if you are connected to JOSH, 'HR' selection is stored, so no value comes out.