Forum Discussion
issue slicer
thanks for the answer Anonymous
I already have the RLS, but one person can see many employees, so if i publish without a selection, on the slicer, the personal is going to see the sum and get confused.
an other solution for my problem is ...when the person open the report, always see the first person (or row) available, without the selection on the slicer before publish needed.
regards
HI santiagomur ,
Can you please share your RLS formula? As I said, if you add a user table with username filed, you can set RLS filter based on current username. This role is dynamic based on current username, it will change filter effect when different users open your report who enabled username RLS.
If you want some users can view multiple users' records, you can add 'user manager' table(manager id, user id) and link to 'user mapping' table, then you can apply RLS filter on 'user manager' table 'manager' field to display multiple users records.
In addition, if you still confused about how to do these, can you please share some dummy data with minimum table structure to test?
Regards,
Xiaoxin Sheng
HI Anonymous Thanks for the answer,
i have a table with the user name and a RLS formula User = UserName()
Example
table 1
User A B C Table 2
User Name Age A Jhon 10 A Peter 20 A Erik 30 B Frank 40 C Nichols 50 step 1
step 2
show as RLS user "A" the filter row is working, but i don't want to see a sum on the age card.
step 3
I select "Erik" and then select to show as RLS user "A", and is perfect only show the names for user "A" the age card is not sum.
step 4
with Erik still selected change the RLS to user "B" now the slicer show me Erik and frank, but Erik is not a name from user "B" what i want its the slicer refresh and only show me Frank.
i know the problem is that i publish with Erick selected but if i publish without, all the visual show sums, and i don't know how to publish without selection and the visuals show the data for the first row available.
( i try do the same with a chicletslicer with forced selection apply and works, when i change the RSL the slicer refresh their values) but my boss whant to use the default visuals.
Anonymous
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
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)