RLS filtering based on SELECTEDVALUE

Question

I'm trying to apply an RLS filter based on the SELECTEDVALUE of a specific table.

I'm looking to implement a feature where the RLS filter is different depending on the report page the user is viewing. One of my pages has a filter set on the table 'Pages' so it only has one value. I then get the SELECTEDVALUE of the 'Pages' table in the RLS filter. When it equals one value, I apply one filter, if it equals another value, I apply the other filter.

Unfortunately, this doesn't work. It's almost as if the SELECTEDVALUE is not working / filtered during RLS evaluation?

amitchandak · Answer

michaeldewaele , Check if You looking for RLS for Page selection 
https://www.youtube.com/watch?v=FrEDZZXiit8

michaeldewaele · Answer

Thanks for your reply! Unfortunatly I'm looking for a solution where the native Power BI page switching can be used. The report is used in a Power BI app so using the native page switcher is a requirement.

Thanks for your reply though!

Forum Discussion

RLS filtering based on SELECTEDVALUE

2 Replies

Related content

SELECTEDVALUE & FILTER based on slicer

partial string filter based multiple selectedvalues

dynamic x-axis based on filter

Selectedvalue

Creating a Calculated Column Based on SELECTEDVALUE