Forum Discussion
Helper IBookmark based on value of field when using row level security
So I'm using role level security to give only data to each user that accesses the dashboard but I have two options "Product A only" & "Product A & B"
So I have various cards I only want to display when the user logged in is "Product A & B"
I can set up the bookmarks but is there a way to show a bookmark based on a data field?
Hi DarylRob ,
According to your description, here's my solution.
1.Create a measure.
Measure = ""Put the measure in a card visual.
Turn off the Category label, get a blank visual.
2.Create a new table by the below formula.
Table 2 = UNION ( ROW ( "Card Color", "#FFFFFF00" ), ROW ( "Card Color", "White" ) )Get this table.
3.Select the fx tab beside the Color option under the Backgroud ribbon.
Select the Card color column from the new table in the color field.
4.In Manage roles, create two roles like below.
5.Put the blank card upon the fact card you want to display.
When you view as No show, there's nothing.
When you view as Show, the fact card display.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
v-yanjiang-msftCommunity Support
Hi DarylRob ,
According to your description, here's my solution.
1.Create a measure.
Measure = ""Put the measure in a card visual.
Turn off the Category label, get a blank visual.
2.Create a new table by the below formula.
Table 2 = UNION ( ROW ( "Card Color", "#FFFFFF00" ), ROW ( "Card Color", "White" ) )Get this table.
3.Select the fx tab beside the Color option under the Backgroud ribbon.
Select the Card color column from the new table in the color field.
4.In Manage roles, create two roles like below.
5.Put the blank card upon the fact card you want to display.
When you view as No show, there's nothing.
When you view as Show, the fact card display.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- amitchandak
Super User
DarylRob , You to create a table with these two values and email ID, what each email can be shown.
Then you can create role
[email] = userprincipalname()
that will filter one of the two or both based on login
How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk
DarylRobBut how do I hide a card for certain users?
