Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DarylRob
Helper I
Helper I

Bookmark 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?

 

1 ACCEPTED SOLUTION
v-yanjiang-msft
Community Support
Community Support

Hi @DarylRob ,

According to your description, here's my solution.

1.Create a measure.

Measure = ""

Put the measure in a card visual.

vkalyjmsft_0-1644828442967.png

Turn off the Category label, get a blank visual.

vkalyjmsft_1-1644828516799.png

2.Create a new table by the below formula.

vkalyjmsft_2-1644829493795.png

Table 2 = UNION ( ROW ( "Card Color", "#FFFFFF00" ), ROW ( "Card Color", "White" ) )

 Get this table.

vkalyjmsft_3-1644829546442.png

3.Select the fx tab beside the Color option under the Backgroud ribbon.

vkalyjmsft_4-1644829643129.png

Select the Card color column from the new table in the color field.

vkalyjmsft_5-1644829793094.png

4.In Manage roles, create two roles like below.

vkalyjmsft_6-1644830020897.png

vkalyjmsft_7-1644830033664.png

5.Put the blank card upon the fact card you want to display.

When you view as No show, there's nothing.

vkalyjmsft_9-1644830241663.png

When you view as Show, the fact card display.

vkalyjmsft_10-1644830272954.png

 

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.

 

 

 

View solution in original post

3 REPLIES 3
v-yanjiang-msft
Community Support
Community Support

Hi @DarylRob ,

According to your description, here's my solution.

1.Create a measure.

Measure = ""

Put the measure in a card visual.

vkalyjmsft_0-1644828442967.png

Turn off the Category label, get a blank visual.

vkalyjmsft_1-1644828516799.png

2.Create a new table by the below formula.

vkalyjmsft_2-1644829493795.png

Table 2 = UNION ( ROW ( "Card Color", "#FFFFFF00" ), ROW ( "Card Color", "White" ) )

 Get this table.

vkalyjmsft_3-1644829546442.png

3.Select the fx tab beside the Color option under the Backgroud ribbon.

vkalyjmsft_4-1644829643129.png

Select the Card color column from the new table in the color field.

vkalyjmsft_5-1644829793094.png

4.In Manage roles, create two roles like below.

vkalyjmsft_6-1644830020897.png

vkalyjmsft_7-1644830033664.png

5.Put the blank card upon the fact card you want to display.

When you view as No show, there's nothing.

vkalyjmsft_9-1644830241663.png

When you view as Show, the fact card display.

vkalyjmsft_10-1644830272954.png

 

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
Super User
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

But how do I hide a card for certain users?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.