Forum Discussion

vini_udenia's avatar
vini_udenia
Helper I
6 years ago
Solved

Row Level Security to be excluded from some visual

Hi, I need to implement security wherein the data should be filtered based on the user logging in: Level 1 -- Director: All Data  Level 2 -- Country Head: Data for managers reporting to him + Few ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    vini_udenia I am not aware of any functionality at this point that allows RLS on toggling visual objects on the page... You would only be able to accomplish this by using variations of the report. ie, creating multiple reports.

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi vini_udenia ,

 

We can use measure as a visual filter as a workaround which will work in some situation:

 

 

Then we create a measure and use in the visual filter:

 

FilterByName =
IF (
    ISFILTERED ( 'Table'[Name] ),
    IF ( SELECTEDVALUE ( 'Table 2'[Name] ) IN FILTERS ( 'Table'[Name] ), 1, -1 ),
    1
)

 

 


BTW, pbix as attached.

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vini_udenia's avatar
vini_udenia
Helper I
6 years ago

Hi, Can you please elaborate this solution a bit further.