Skip to main content
Microsoft Idea

Power BI

Needs Votes

Allow default filtering based on current user

Vote (287) Share
TL's profile image

TL on 07 Jul 2017 22:48:52

It would be nice, even if not essential, to allow a report to slice by default to the current user's data. For instance, I might envision:

- A dimUser table that can slice by default to the USERNAME () output
- A dimGeo table that can slice by default to the city/state/country of the session's IP address
- ...and so forth

Comments (29)
TL's profile image Profile Picture

Vincent Chevalier on 23 Nov 2023 19:46:47

RE: Allow default filtering based on current user

We need this to default to the UserPrincipal country so they see their native currency upon log in. But we would like to give them the choice to chose other currencies if they wish to change.

TL's profile image Profile Picture

Kaveh Moaed Zadeh on 21 Jun 2023 09:30:39

RE: Allow default filtering based on current user

Please develop this. There are so many benefits to this. There are probably lots of large companies that have a structure that separates report developers from PowerBI governance where security model etc. are maintained. There are lots of reasons governance cannot always make changes to the security model. This feature would make developers somewhat independent of the security model. Everyone please share this with your PowerBI network and ask them to vote. Thanks a lot!

TL's profile image Profile Picture

Mary Aho on 17 May 2023 19:59:15

RE: Allow default filtering based on current user

This is so critical to make RLS and other use cases function to their fullest. Currently if a user is a member of a workspace, RLS will not work for them. There are use cases where a user is a developer and needs full access to a workspace or dataset, but needs a report defaulted to their "security level" permissions in line with other users of their attributes. I'm astonished this isn't accounted for in perhaps a desktop options checkbox or somewhere, especially considering workspaces can be shared across large development groups, and users.

TL's profile image Profile Picture

Philip Ostermeier on 12 May 2023 14:38:02

RE: Allow default filtering based on current user

+1 !

TL's profile image Profile Picture

Shima Nejabat on 05 Jan 2022 18:37:14

RE: Allow default filtering based on current user

Allow default filtering based on current user

TL's profile image Profile Picture

Mohamed Alraghib on 28 Dec 2021 17:32:18

RE: Allow default filtering based on current user

this is needed

TL's profile image Profile Picture

Eric Klamm on 20 Dec 2021 20:11:52

RE: Allow default filtering based on current user

Would be really useful to create customized landing pages in reports for different users or departments.

TL's profile image Profile Picture

Kaushal Vyas on 28 Oct 2021 15:51:52

RE: Allow default filtering based on current user

Need this feature to default the slicer selection to a particular value rather than filter it for that value. This allows users to see default value data on landing, but if needed change slicer selections to other possible values

TL's profile image Profile Picture

Andrew Cason on 25 Jun 2021 15:50:07

RE: Allow default filtering based on current user

Critically needed so we can create metric based reports for our general user base and automatically send these.

TL's profile image Profile Picture

Power BI User on 10 Jul 2020 17:20:43

RE: Allow default filtering based on current user

Really badly needed feature.