Hide visuals / Target line based on Roles

[Anonymous]

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

[v-jingzhang]

Hi @Anonymous 

Maybe you can consider creating different pages for different roles and showing corresponding pages based on roles.

Did you know you can now selectively show report pages for specific users in Power BI? - Reporting/Analytics Made easy with FourMoo and Power BI

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[Anonymous]

@v-jingzhang  what i understand from page navigation is just hiding the url , but what happen if someone share the the url of that page 

[v-jingzhang]

@Anonymous yes that is correct. This is not fully secure but a hide/show behavior at the view layer. If someone shares the url of a hidden page, other people can view the page too.

To my knowledge, constant lines in Analytics pane are not able to be shown or hidden according to roles. 

[Greg_Deckler]

@Anonymous In theory, yes using RLS but hard to tell you specifics with the information provided.

[Anonymous]

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 

[Greg_Deckler]

@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.

[Anonymous]

@Greg_Deckler no , its just a constant line

[Greg_Deckler]

Spoiler

@Anonymous 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.