Forum Discussion

santiagomur's avatar
santiagomur
Resolver II
6 years ago

issue slicer

Hi,    how i can force the slicer pick the first value always.    my problem i have a report that have a role filter, if i have someone selected on the slicer and then i changes the role, the sli...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI santiagomur ,

I  think you are misunderstanding with RLS filter. RLS filter on applying on data model level, it will directly apply changes on data moel table records. (RLS filter will change source table records, slicer/filter not effect table records) 

After you setting RLS based on username and publish to services and assign roles to your users with read permissions.  Report contents will be filtered on the data model level and these not matched records do not load to current report that they viewed.

BTW, current power bi does not contain options to setting defaut value on slicers.

Regards,

Xiaoxin Sheng

santiagomur's avatar
santiagomur
Resolver II
6 years ago

HI Anonymous 

 

I understood,  but if a role have permissions to see many row the first visual they get is a sum of all the row, until a filter is made. 

 

i'm looking for a solution for this roles that have many rows, what i need is the report show by default the first row,  to avoid the sum. (what i doing  now is to select someone on the filter and then publish, but the refresh filter scenario happens)