Our customer asking us if is possible to hide some chart objects within a sheet based on user profile.
I know i'm able to hide a whole sheet object through security rules.
Please let me know asap.
Many thanks in advance.
As far as I am aware there are no options to show or hide objects.
It's probably on the roadmap.
The best you can do is probably to have the expression change so that it returns null, and the chart will then simply show a message saying that there is no data.
Retrieving data ...