Forum Discussion
Hide visuals / Target line based on Roles
Hello All, can we hide a visual / Target line from line or bar chart based on Roles. main purpose is we don't want to show target or some confidential KPI to all user. Thanks Pragati
Anonymous In theory, yes using RLS but hard to tell you specifics with the information provided.
Hi Greg_Deckler ,
Ex:- lets say
1. we have a line graph with Target constant line which are showing to every user but client don't wanna to show target line to every employee. so we have to hide target line for some user/Role.
2. we have to also hide some KPI or visuals based on Role.
is there any way we can achieve this thing
Anonymous That's great. Where does TargetLine come from? If you put this into it's own table using an Enter Data query then you could restrict access to this table via RLS and then no target line.
Greg_Deckler no , its just a constant line
- SpoilerAnonymous right, so just put it into a table using an enter data query. Create a measure for it, any aggregation. Implement RLS on that table. Add the measure to your visual.