slicer showing all after the report has a page filter passed on

[Anonymous]

Hi, 

I am passing filters from on report to another in the URL for the receiving report. 

The thing is that the receiving report takes it as a page filter and applies it, Which is fine in itself. 

It also affects the slicer. So, if I pass UK as a country, UK is set as a page filter and used to update the slicer. The not so nice bit is that the slicer will show all in a normal state and all and UK in dropdown, which is confusing the users.

Is there a way to not show all, but UK in the slicer for this case?

[v-yalanwu-msft]

Hi, @Anonymous ;

Try setting up an RLS. 

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

https://www.biconnector.com/blog/power-bi-steps-to-setup-rls-row-level-security-static-and-dynamic/

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for this, but I am referring to the slicer showing the value "all", even when there is only one selection made. I would want it to show that value, iso "all".

[lbendlin]

Not really.  You may want to raise it as an idea for changing the slicer UX if it only has a single value.