This is yes or no question, probably really simple one.
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.
Is there someone who has a solution for this problem in the meantime?
If want to do the same thing as asked here so I was wondering if someone has some tips on how to do this.
Thank you in advance!
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.
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:
@skusulja , check if you are able to create a measure like this
This can be used in visual level filter
This measure returned blank for me.
I tried couple of variations but I didn't get what I wanted.
Anyway, this was supposed to be a small addition to my report, I'm not supposed to spend any more tome on this and we can go without it.
Thank you all for your comments!
Hi @skusulja ,
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
Hi @skusulja ,
You can look into Row-level security in Power BI.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.