issue slicer

Question

Hi,&nbsp;&nbsp;how i can force the slicer pick the first&nbsp;value always.&nbsp;&nbsp;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 slicer still with the last selection (all the visuals blank), then if i change the selection on the slicer it refresh and show the good ones.my case the slicer contains name of competitors so i need the role filter automatic show the real values on the slicer and pick the first value (don't&nbsp;want&nbsp;to show all summarized).&nbsp;&nbsp;&nbsp;example&nbsp;tabla A (role)user 1user 2user 3&nbsp;table B&nbsp;user 1&nbsp; &nbsp; &nbsp; &nbsp; Employee&nbsp;1&nbsp;user 1&nbsp; &nbsp; &nbsp; &nbsp; Employee&nbsp;2user 2&nbsp; &nbsp; &nbsp; &nbsp; Employee 1.1user 2&nbsp; &nbsp; &nbsp; &nbsp; Employee 2.2user 3&nbsp; &nbsp; &nbsp; &nbsp; Employee 1.3&nbsp;then i publish with someone selected to avoid the summ. (for the example i pick the employee 1 and then publish)&nbsp;then i&nbsp; log&nbsp;us user 2 the slicer show me employee 1.1 and 2.2 and by default employee 1 is select with all the visuals blank, if i unselect the employee 1 it desapears and show the real ones.&nbsp; on this case i am showing to user 2 a name of 1 employee of user 1.&nbsp;&nbsp;&nbsp;so i need the slicer refresh and show only the real ones or a way to publish the report with the first row select by default.&nbsp;&nbsp;&nbsp;best regards&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

HI&nbsp;santiagomur&nbsp;,
AFAIK, current power bi does not support to set a default value on slicer/filter.
According to your description, I'd like to suggest you enabled RLS filter on your report to filter records, it will apply filter effect on 'data model' side. (filter/slicer not able to affect RLS filter)
RLS with UserName()
Row-level security (RLS) with Power BI
Regards,
Xiaoxin Sheng

santiagomur · Answer

thanks for the answer&nbsp;Anonymous&nbsp;&nbsp;&nbsp;I already have the RLS, but one person can see many employees, so&nbsp;&nbsp;if i publish without a selection, on the slicer, the personal is going to see the sum and get confused.&nbsp;&nbsp;&nbsp;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.&nbsp;&nbsp;regards

anonymous · Answer

HI&nbsp;&nbsp;santiagomur&nbsp;,
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.&nbsp;&nbsp;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&nbsp;'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

santiagomur · Answer

HI&nbsp;Anonymous&nbsp; Thanks for the answer,&nbsp;&nbsp;i have a table with the user name and a RLS&nbsp; formula User = UserName()&nbsp;Exampletable 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;UserABC&nbsp;Table 2UserNameAgeAJhon10APeter20AErik30BFrank40CNichols50&nbsp;step 1&nbsp;&nbsp;&nbsp;step 2&nbsp;show as RLS user "A" the filter row is working, but i don't&nbsp;want to see a sum on the age card.&nbsp;step 3&nbsp;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.&nbsp;&nbsp;step 4&nbsp;with Erik&nbsp;still selected change the RLS to user "B"&nbsp; now the slicer show me Erik&nbsp;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&nbsp;i publish with Erick&nbsp;selected but if i publish without, all the visual show sums, and i don't&nbsp;know how to publish without selection and the visuals show the data for the first&nbsp;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.&nbsp;&nbsp;Anonymous&nbsp;

anonymous · Answer

HI&nbsp;santiagomur&nbsp;,
I&nbsp; 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)&nbsp;
After you setting RLS based on username and publish to services and assign roles to your users with read permissions.&nbsp; 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,&nbsp;current power bi does not contain options to setting defaut value on slicers.
Regards,
Xiaoxin Sheng

Forum Discussion

issue slicer

6 Replies

Related content

Slicer issue.

Slicers issue

Slicer issue !!

List Slicer Visual Issue

Relationship/Slicer Issue