Filter by user logged in

Question

Hello everyone,This is yes or no question, probably really simple one.&nbsp;I have report which contains data about employees. How much cases they solved, how many hours they spent resolving certain issues etc. - basically it's their performance. Data is filtered by employees and teams and everyone can see everything. Question is - when an employee opens that report, can those filters be automatically selected so it shows data for that one person who opened the report? So it would probably be a DAX formula which goes to filter/slicer and selects employee based on user who is logged in and who is viewing the report.&nbsp;

pragati11 · Answer

Hi&nbsp;skusulja&nbsp;,&nbsp;If you are planning to share a single dashboard to multiple users then Row-Level security is the approach that should adopt.If you are planning to distribute multiple dashboards for individual users than you can go with filter on Username. But, this approach is not the right way to go forward with.&nbsp;Thanks,Pragati

tahreem24 · Answer

skusulja&nbsp;,
Yes, When you apply RLS (to restrict users from viewing data) so automatically all the report contents will be filtered out based on the permission of users who logged.
&nbsp;

hkusulja · Answer

This is simple question about using Power BI Report in web.Example is Sales report, where Filter (on page for example or visualization) persists, and should be default set to current user.But user should be able to change this filter and see other sales performance in power bi report for other users.It is just a question on setting value to a current filter (page filter or visualization filter) for which user to display the data.It does not have nothing with Power BI Dashboards, nor Row level security

pragati11 · Answer

Hi&nbsp;skusulja&nbsp;,&nbsp;You can look into Row-level security in Power BI.https://radacad.com/row-level-security-configuration-in-power-bi-desktop&nbsp;Thanks,Pragati

skusulja · Answer

I do not want row level security (RLS) as a feature. I need that all data is visible to others. Just default that it is filter (visualization) to a particular user.

I have thought to add new DAX column to my Users table with expression:

CurrentUser = IF(USERPRINCIPALNAME()=Employees[SystemUser.UserName],TRUE(),FALSE())

However, I have error:

CUSTOMDATA, USERNAME, USERCULTURE and USERPRINCIPALNAME functions are not supported in calculated tables/columns. These functions may only be used in Measures or in the AllowedRowsExpression.

Ok, but is there any other way to set default filter on visualization to a current user?

Forum Discussion

Filter by user logged in

8 Replies

Related content

How to set user filter based upon the logged in user without using RLS

Fabric & Azure Data User Group Program Requirements & Benefits

Logging

Logging Applied Filters in Power BI Report Server

Community User Group Experience