Forum Discussion
Helper IBookmark based on value of field when using row level security
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.
Community SupportHi 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.