Forum Discussion
Solved
hide a sheet dynamically
Hi I got 2 sheets PUBLIC and PRIVATE in my report and PRIVATE should be accessible only for some users and according to a specific list of projects (2 conditions). I've got 3 tables. ...
Well, one of my colleague solved it by modifying the Button Text measure:
Button text = VAR nbpjt = count(Users[ProjectId]) VAR typpjt = IF(SELECTEDVALUE(Users[HideSheet]) = 1,"GO TO PRIVATE","") RETURN IF(nbpjt > 1, typpjt, typpjt)Bye,
CR
