Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
56 | |
19 | |
18 | |
18 | |
9 |