Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
In Rls I don't want to show any country value to a user how can i do that any ideas? For example in above image i am showing only East region and i will add emails of the people they can see only East region. In My case i don't want to show any region to some users how can i do that?
Thanks in advance
Solved! Go to Solution.
Hi , @Anonymous
You can follow the steps below .
More info about hiding the table to some users , you can refer to the link below .
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi , @Anonymous
You can follow the steps below .
More info about hiding the table to some users , you can refer to the link below .
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Burningsuit ,
Thanks for detailed explanation, In my current case i have table visual with three rows of data. I want to hide the table to some users. Is there any way to apply RLS to specific visual like table visual.
Hi @Anonymous
There are many different ways you could accomplish this, depending on what is wanted and how your data is structured.
You could have a RLS role with the DAX expression '[Region] <> "East"' which would allow viewing of any records NOT in the East Region.
You could have a DAX role with the DAX expression '[Region] <> "North" || [Region] <> "South" || [Region] <> "East" || [Region] <> "West"'
which would only show Regions NOT in North, South East or West.
Or you could have a role whith the DAX Expression 'ISBLANK([Region])' which would only show blank Regions.
You have the whole DAX language to create an expression that evaluates to TRUE, it then depends on your data on how to impement it.
Hope this helps
Stuart