Forum Discussion
issue slicer
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)