Skip to main content

Power BI

Needs Votes

Allow default filtering based on current user

Vote (173) 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 (20)
TL's profile image Profile Picture

8ef4fd29 6292-40bb-965a-a5a129d34d45 on 05 Jul 2020 23:25:39

RE: Allow default filtering based on current user

Desperately need!!! We don't want to use security because we want to allow users to see all reports. But instead default to their view to avoid having to drilldown into the reports every time.

TL's profile image Profile Picture

ca2c8282 3aed-4fb0-92fc-652b5e48656f on 05 Jul 2020 23:20:42

RE: Allow default filtering based on current user

Really need this feature!

TL's profile image Profile Picture

2db04237 75ee-e911-a812-000d3a4f1ebb on 05 Jul 2020 23:18:01

RE: Allow default filtering based on current user

Mandatory feature !!!

TL's profile image Profile Picture

6118b675 06e2-e611-8100-5065f38b21f2 on 05 Jul 2020 23:15:48

RE: Allow default filtering based on current user

yes we need this!

TL's profile image Profile Picture

c9d23892 848d-476a-876a-e7066f709d08 on 05 Jul 2020 23:15:32

RE: Allow default filtering based on current user

Mandatory feature

TL's profile image Profile Picture

4d614242 5f22-4561-ae19-97d2ccc7eab1 on 05 Jul 2020 23:08:45

RE: Allow default filtering based on current user

Yes I would like to see this feature available in the mobile app as well. A sort of "default state" or "favorite" view specific to the current user, that they can configure and save. Then open back up later in as few screen clicks as possible.

TL's profile image Profile Picture

4a3fc996 a08f-435a-b2c4-bc16ccfe2b72 on 05 Jul 2020 22:59:35

RE: Allow default filtering based on current user

Very much needed!

One example of what we need is to look up the current user's office and set the office slicer to default to that office. We do not want to restrict the user from selecting other offices. Just save them the clicks of having to select their own office every time they go into the report.

Add a section under formatting for a slicer and allow an measure or DAX code to be entered.

TL's profile image Profile Picture

cbece431 f579-437a-a67f-1e4f1dbba62e on 05 Jul 2020 22:56:59

RE: Allow default filtering based on current user

Ditto, very needed feature, similar to default member / username function in MDX.

TL's profile image Profile Picture

bbbfb089 4bce-e911-a96a-000d3a4f36ce on 05 Jul 2020 22:56:26

RE: Allow default filtering based on current user

Really need this feature for personalized Reports and Dashboards!

TL's profile image Profile Picture

64d512c5 c618-4156-b459-e99cc8d236a1 on 05 Jul 2020 22:53:11

RE: Allow default filtering based on current user

(This would be entirely distinct from security, since it wouldn't *hide* non-matching rows, but just slice to the matching ones for tables on which it's enabled.)