Forum Discussion
Data Labels with Security Policy
HI JorisVoorn ,
I don't think it is possible to use hierarchy field to achieve your requirements in pie chart.
In my opinion, I'd like to suggest you add a calculated column to group your fields to the original name and other, then you can use this field to replace the original data category to mask these detail types which you used on pie chart.
Regards,
Xiaoxin Sheng
Dear Xiaoxin,
That is not solution for my problem, as your proposal would solve that just for one particular account, the core of issue is that I would need to have shown Account flexible based on access rights of users (RLS).
BR
Pavel
Hi JorisVoorn
I believe you can use RLS to achieve this. Create 2 roles, "All Access View" and "Limited Access View". For All Access View, you can leave it as it is. For Limited Access View, you can create a filter expression in the "Manage Roles" function that does something like this: If Table[Partner] = "AAA" then "AAA" else "Others"
I am not entirely sure about the syntax but that's the logic of it.
When you publish this up to Services, remember to assign everyone that has access to the report the roles they should have, else, they will not be able to view the visual.
Hope this helps!
Daren
Sorry but my issue was still not resolved, so could any moderator please uncheck topic as solved and unmark this reply as solution?
Thank you for reply, but case I have presented was just demonstration of issue, for one partner your solution would be possible to use, but as caclulated column is not dynamicly changing based on filters I would need to create masked other partners for every singly partner and in case you imagine 50+ partners this solutions would lead to unamanageble solution.
Best regards
Pavel
