topic Re: Default value for Slicers in Developer

Default value for Slicers

ravi_n — Wed, 18 Sep 2024 17:03:08 GMT

Hello Power BI Community,

We have a requirement to set default values/pre-selected for slicers based on Slicer of different table. We have visualizations and filters on 2 reports, coming from different tables which are not linked.

Table 1 - Has RLS applied, Visualization and Filters and RLS
Table 2 - Visualization and Filters

Slicers value selected in Table 1 report page, should be applied by default when we navigate to reports from table 2 and its filters.

We are not linking table 1 and 2, since RLS requirement on table 1.

Appreciate any help to achieve this.

Regards,
Ravi

Re: Default value for Slicers

lbendlin — Wed, 18 Sep 2024 19:29:35 GMT

Slicers value selected in Table 1 report page, should be applied by default when we navigate to reports from table 2 and its filters. We are not linking table 1 and 2, since RLS requirement on table 1.

Those requirements seem to contradict each other.

BIG WARNING NOTE: Default slicer values and RLS are incompatible!!!

Re: Default value for Slicers

ravi_n — Thu, 19 Sep 2024 11:26:31 GMT

@lbendlin Thanks for the update