Skip to main content

Power BI

Under Review

Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

Vote (51) Share
Wouter's profile image

Wouter on 20 Dec 2014 05:03:19

Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

While user A opens a report the filter is set to his/her name (or his/Hers departement he/she is connecten to) while user B opens the report the filter is set to User B. Users not should not be able change that filter.

That would be great

Administrator on 20 Dec 2014 07:35:44

Do you mean at the dashboard? Adding filters in general is something we'd like to add, and these 'standard' filters could be options as well. Thanks for suggesting! If others agree, please add your votes!

Comments (9)
Wouter's profile image Profile Picture

88280aca 07e7-465e-bb28-8831c627adf4 on 05 Jul 2020 23:14:03

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

We'd like to see this as well. On a report or dashboard that is shared through the app or embedded in a SharePoint communication site, it'd sure be nice if reports would show the information that user has been given access to. For example, it'd be best if a project manager of one job is looking at a SharePoint page that has a report that shows revenue, fee, status of a company's projects, instead of all the projects having to be shown, it'd be great if only the project that user is associated with are shown. Otherwise, we'd have to spin up a separate SharePoint site for each project, and create a filter for each PowerBI report. Managing a few core reports and some form of a user access / permissions module sounds administratively more feasible than having to manage a ton of manually filtered reports. To add to that, managing a permission filter by user, role or group would be ideal.

Wouter's profile image Profile Picture

1e4da31b 5360-4a92-8360-1fff89a57cc0 on 05 Jul 2020 22:56:07

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

Original idea could be resolved by row level security in some scenarios. The part I would like to vote is the ability to hide/show filter pane and to give developers the option to set page/report level filters' visibility.

Wouter's profile image Profile Picture

0a756d1b fac5-4b2d-aa70-f3a338663980 on 05 Jul 2020 22:31:47

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

In my case I have 1 dataset on sales. They want to analyse closed salesorders on one page and open salesorders on another page. When using a page level filter to distinguish open of closed salesorders, the end user is able to alter the filter. This is not what we want. This filter should be fixed in reading mode.

Wouter's profile image Profile Picture

e623699f 7a5d-4812-ab1b-5fc502f7861f on 05 Jul 2020 22:29:55

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

Although a lot of the examples provided are covered by Row level security, I would still like a way to not allow Object/Chart filtering, so that I can set a visual level filter and users cannot change it.

Wouter's profile image Profile Picture

431581a6 37a5-4ca4-bafe-46baf59d7e7a on 05 Jul 2020 22:16:21

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

We have a similar situation mentioned by Quiten. We need to create a standard dashboard for 50 leaders and they should only be able to see the data only for their individual teams. Thanks Power BI team

Wouter's profile image Profile Picture

277a0d29 24d0-4c49-a896-8a1b96d693cf on 05 Jul 2020 22:12:57

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

I agree as well. Same as Quinten. I'm going to create a dashboard to 20 agents to check their own statistics and I don't want them to check their colleagues :)

Wouter's profile image Profile Picture

cfa1c61a 94aa-4a69-b45f-868213f0d96f on 05 Jul 2020 22:12:40

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

I agree... I am pushing the dashboard to 50 different agents and i do not want them to she the other agents reports or filter to show all agents. This would be a fantastic feature.

Wouter's profile image Profile Picture

6c9e0210 cd55-4eb1-b4ee-edffeee9dc9e on 05 Jul 2020 22:03:45

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

At the dataset level would be great. This way all level of visualization apply the same filtering

Wouter's profile image Profile Picture

ab68761e 98ec-48c5-af66-ad3493441c8d on 05 Jul 2020 22:02:27

RE: Hidden prefixed filters or read only prefixed filters. Like username or last 30 days.

Page filter in reports with option to be hidden from users (other than owner) would be great addition.

For eg.
My report had multiple page filter to arrive at correct data for that page objects.. Some filter I want user to change.. some should be restricted (only owner can view and/or change)