Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Row level security two values

Hi team,
my table two rows and two columns

customer frequency
ABC daily
ABC intradate
both column are drop down slicer in my report
my problem is:
user name:shanvitha
view only ABC and daily data filters
another user only lavidiya
both values based on filters
when select customer its show ABC
frequency need show daily and intradate


how to achieve this

thanks
shanvitha
Need Help
  • d_gosbell's avatar
    d_gosbell
    7 years ago

    Create 2 roles, 

     

    Role1 has a filter on your table with an expression like: 

    table[Customer] = "ABC" && table[Frequency] ="daily"

     

    Role2 has no filters applied.

     

    Then you put shanvitha in Role1 and lavidiya in Role2

1 Reply

  • d_gosbell's avatar
    d_gosbell
    Super User
    7 years ago

    Create 2 roles, 

     

    Role1 has a filter on your table with an expression like: 

    table[Customer] = "ABC" && table[Frequency] ="daily"

     

    Role2 has no filters applied.

     

    Then you put shanvitha in Role1 and lavidiya in Role2