Bookmark based on value of field when using row level security

[DarylRob]

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?

[v-yanjiang-msft · Accepted solution]

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 _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@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

[DarylRob]

But how do I hide a card for certain users?