Filter on User Principal Name without RLS

[Hardik_Patel_29]

A dashboard has charts which could be Filtered by Users.

But a user should also have the ability to Filter the charts and show only his data.

Basically  a User should be able to see all the data and instead of searching his own name, with a button he should be able to filter the charts for his name. 

How do I add this feature?

Since the Slicer and Filter cant work on anything which has UserPrincipalName() or any measure which has UserPrincipalName in it.

[Anonymous]

Hi @Hardik_Patel_29 

I would prefer @lbendlin 's suggestion as that is the easiest way to do it right now. I'd like to add that you can also teach your report users to create and use personal bookmarks(Overview of bookmarks in Power BI service reports - Power BI | Microsoft Learn).

Your idea is great, but there is currently no direct approach to it. UserPrincipalName function can only be used in a measure, however a measure cannot be used as a page-level or report-level filter. And a button cannot trigger a filter which need to be dynamic. Due to these limitations, we cannot use a button to trigger a filter on all visuals based on User Principal Name without RLS. 

You have to use a slicer or the filter pane to let users search his own name manually the first time, then create a personal bookmark by their own. Thus they can click their personal bookmark to see their own data immediately. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!

[lbendlin]

Add the user ID to the report level filters.

Allow your users to store their filter choices

Teach them how to use the filter pane.