I wonder if Power BI can satisfy the following scenario :
The reports checks different filter based on user identity by default. ie: there is a filter related to managers' name, I want to make the dashboard check manager1 filter by default when manager1 log on, and check manager2 filter by default when manager2 log on.
And I have tried the username() measure in Power BI, username() returns users' identity when he\she logs on,. However, username() is a mearure, it seems “CUSTOMDATA and USERNAME functions are not supported in calculated columns”. Which means I can not use IF( [someColumn] == [usrername] ) , does this measure help in this scenario ?
So, is it possible fo Power BI to realize it? And how ?
@qifzhou Can you try row level security to achieve this. So create a role then use username() function in it to identify logged in person and write DAX query to filter. Obviously that means your data has filtering has to be done via rows and since I don't know your data structure I can only think of this approach to try.
The point here is I want to keep user possible to see all data. Using row level security, I can achieve filtering data based on user’s identity but user won’t be able to change the filter and see all data.